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

why didnt you post what the problem is?

Hi Pinku,

First, does your nls_date_format match on both databases?



>> 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

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

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';