Help - Search - Members - Calendar
Full Version: datalink problem
Oracle DBA Forums > Oracle > Oracle Forum
pinku
i want to connect ma database with the other using 10g but the date format creats the problem.......
i have used format specifier but the problem is still thr
please help me for this
regards
pinku
dave
why didnt you post what the problem is?
burleson
Hi Pinku,

First, does your nls_date_format match on both databases?

CODE
SQL> show parameter date


>> please help me for this

OK, post the error and we will get started . . .

Here are some general tips:

http://www.dba-oracle.com/t_how_create_database_link.htm
pinku
QUOTE (dave @ Oct 31 2008, 03:03 PM) *
why didnt you post what the problem is?

hi!!!!
i have crated a database link easily with the other database but problem is about date format matching.....actualy i wana match a date of one data base with the start and end date of the other database and on this base i wana pick a record......
the date format in one database is this 31-OCT-2008 and in other is this 2/1/2008
please help me
regards
pinku
burleson
Hi Pinku,

Judging by your questions, it appears that you have not had the benefit of the required DBA training.

Is this correct?

If so, administering a production system can be very dangerous.

If you cannot get the Oracle University DBA class, get the "Easy Oracle" books, pronto:

http://www.rampant-books.com/menu_six_packs_bundles.htm#easy

*************************************************************************
>> the date format in one database is this 31-OCT-2008 and in other is this 2/1/2008

OK, which do you want to use? READ THIS:

http://www.dba-oracle.com/t_nls_date_format_sysdate.htm

OK, adjust the NLS_DATE_FORMAT parms to match. READ THIS CAREFULLY:

http://www.dba-oracle.com/sf_setting_parameters_tips.htm

In each init.ora (or spfile) change NLS_DATE_FORMAT='dd-mon-yyyy';
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.