Oracle Database Discussions

Hi all,

I have two dbs namely commondb and db1.

I have a table named table1 in commondb under scott user.

I have created a dblink link1 from db1 to commondb using scott user id and password.

Also have created a synonym in db1 under synonym.

scott@db1> create synonym table1 for table1@link1;

Synonym created.

scott@db1> Select count(*) from table1;

4800

I created a proxy id scott_prx in db1 and have created synonym for the synonym scott.table1.

sys@db1> create user scott_prx identified by XXXX;

sys@db1> create synonym scott_prx.table1 for scott.table;

synonym created.

Im getting this error while selecting the synonym created under scott_prx.

scott_prx@db1 > select count(*) from table1;

"ORA-02019 Connection description for remote database not found"


How to resolve this?

Is there any alternate way of doing this without creating a db link under proxy id.

Thanks,
Prem