This content has been marked as final. Show 2 replies
Omega3 wrote:No, it has nothing to do with the version and it has nothing to do with the database link. You said it yourself -- "ND_NAMES Table does exist in the remote schema SCOTT"
Remote Schema in 18.104.22.168 DB
In 22.214.171.124 DB , I created a DB link pointing to a schema in an 126.96.36.199 DB
IND_NAMES Table does exist in the remote schema SCOTT. Anyone faced a similair issue with DB Links?
-- Used the new 11.2 syntax (similar to easy connect ) SQL > CREATE DATABASE LINK dropLater CONNECT TO SCOTT IDENTIFIED BY SCOTT_123 USING 'blpclst-scan.ap.haster.com:3587/SNPG_AP.ap.haster.com'; Database link created. SQL > select count(*) from ind_names@dropLater; select count(*) from ind_names@dropLater * ERROR at line 1: ORA-00942: table or view does not exist ORA-02063: preceding line from DROPLATER -- But the Sysdate from dual test is working fine SQL > select sysdate from dual@DROPLATER; SYSDATE -------------------- 21 Nov 2012 13:24:29
I think this issue is due to version difference ( 188.8.131.52 to 184.108.40.206 )
So, you are connecting to the remote database as SCOTT, who, by your own admission, does NOT own a table named ND_NAMES. And when you try to query it you get "table or view does not exist"
What do you expect?
I don't think that the different version is giving the problem.
It looks that user SCOTT does not have access to that table in remote database.
It seems weird if you say that IND_NAMES table does exist in the remote schema SCOTT.
Could you run the following statements and see objects belonging to user SCOTT in remote db?
If the table exists in remote schema SCOTT it should appear in the output among the other objects owned by schema SCOTT.
SELECT * FROM user_objects@droplater;
Edited by: Alberto Faenza on Nov 21, 2012 2:55 PM