| Database link active but could not be able to resolve object resolution [message #67551] |
Sat, 02 October 2004 05:16  |
Muhammad Rashid
Messages: 4
Registered: September 2004
|
Junior Member |
|
|
I am using two Oracle 9i databases named below:
shaddu01.BSW2K01.AIT.COM
shaddu01.BSW2K02.AIT.COM
global_names = true on both databases
I created following database link on shaddu01.BSW2K01.AIT.COM
CREATE PUBLIC DATABASE LINK shaddu01.BSW2K02.AIT.COM
CONNECT TO scott IDENTIFIED BY tiger
using 'abc'
service name 'abc' is working properly.
scott user is created on both database and have all necessary privilages.I created all default data on scott schema by run "demobld" script file.
When we test databaselink from Oracle Enterprise manager, it shows that database link active.Problem is When I try to access data by following command
select * from emp.shaddu01.BSW2K02.AIT.COM
It shows object not found.
Please help me in this regard.I will be very thankful.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
