Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

dblink error ORA--02063

VipinKJan 6 2010 — edited Jan 7 2010
Hi,
I have 2 databases i.e test and test1.

I created one public database link test_dblink@test1(from test database).

test database having 2 schemas : i.e schema1 and schema2

When i executed one query using schema1 on test database as below :

select * from table@test_dblink--- it works

but when i executed the same query through schema2 on test database it is giving :

Error : ORA-00942 table or view does not exists|ORA--02063 : preceding line from test1

kindly help me :

thanks in advance
This post has been answered by Girish Sharma on Jan 7 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 4 2010
Added on Jan 6 2010
21 comments
44,596 views