dblink error ORA--02063
VipinKJan 6 2010 — edited Jan 7 2010Hi,
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