| URGENT, Quick Help!!!!!!!!! DB link issue [message #58090] |
Wed, 30 July 2003 03:19  |
Tushar
Messages: 17
Registered: November 2001
|
Junior Member |
|
|
I am trying to get some value in instance B from Instance A.
When i execute 'select * from all_db_links' on Instance A, i get this:
Owner DB_LINK Username Host
PUBLIC |TEST |RHE |InstanceB.world=.....
But, when i excute 'select * from schema.object@TEST', at Instance A, it gives me ORA-02019.
There is a DB link between the 2 instances, even then, why am i encountering this error???????
Please respond ASAP.
|
|
|
|
| Re: URGENT, Quick Help!!!!!!!!! DB link issue [message #58103 is a reply to message #58090] |
Wed, 30 July 2003 22:14  |
Dhiren
Messages: 43
Registered: July 2002
|
Member |
|
|
Hi
0) Set GLOBAL_NAMES = FALSE in init.ora (RESTART INSTANCE)
1) First Update the TNSNAMES.ORA file in base database from which u want to select other database with connection to target database to which u want to connect.
2) Then Create the database link in Base Database;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
