Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
> datalink problem
pinku
post Oct 31 2008, 04:51 AM
Post #1


Newbie
*

Group: Members
Posts: 2
Joined: 31-October 08
Member No.: 38,627



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
Go to the top of the page
 
+Quote Post
 
Start new topic
Replies (1 - 4)
dave
post Oct 31 2008, 05:02 AM
Post #2


Advanced Member
***

Group: Members
Posts: 5,206
Joined: 8-October 04
Member No.: 785



why didnt you post what the problem is?
Go to the top of the page
 
+Quote Post
burleson
post Oct 31 2008, 08:11 AM
Post #3


Advanced Member
***

Group: Members
Posts: 11,508
Joined: 26-January 04
Member No.: 13



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


--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post
pinku
post Nov 2 2008, 11:34 PM
Post #4


Newbie
*

Group: Members
Posts: 2
Joined: 31-October 08
Member No.: 38,627



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
Go to the top of the page
 
+Quote Post
burleson
post Nov 3 2008, 09:40 AM
Post #5


Advanced Member
***

Group: Members
Posts: 11,508
Joined: 26-January 04
Member No.: 13



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


--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 23rd September 2014 - 07:18 AM