Database link active but could not be able to resolve object resolution [message #75555] |
Sat, 02 October 2004 05:07 |
Muhammad Rashid
Messages: 4 Registered: September 2004
|
Junior Member |
|
|
I am using two Oracle 9i database named below:
shaddu01.BSW2K01.AIT.COM
shaddu01.BSW2K02.AIT.COM
global_names = FALSE
I created following database link on BSW2K01.AIT.COM
CREATE PUBLIC DATABASE LINK shaddu01.BSW2K02.AIT.COM
CONNECT TO scott IDENTIFIED BY doe
using 'abc'
service name 'abc' is working properly.
When we test databaselink from Oracle Enterprise manager, it shows that database link active.When we trying to access data from "shaddu01.BSW2K02.AIT.COM".
It shows object not found.
Please help me in this regard.I will be very thankful.
|
|
|