Hi,
We've got the following Problem with Public Synonym and Dblink :
Database A (QCRM) :
---------------------------
Object :
PS_NAP_DELV_SHIP (Table)
DROP PUBLIC SYNONYM PS_NAP_DELV_SHIP;
CREATE PUBLIC SYNONYM PS_NAP_DELV_SHIP FOR PSSYS.PS_NAP_DELV_SHIP;
User : ERP_USER
GRANT DELETE, INSERT, SELECT, UPDATE ON PSSYS.PS_NAP_DELV_SHIP TO ERP_USER;
Database B (TERP) :
--------------------------
Database Link :
CREATE PUBLIC DATABASE LINK "CRMDB.BEZEQINT.CO.IL"
CONNECT TO ERP_USER
IDENTIFIED BY <PWD>
USING 'QCRM';
When Executing the following Sql*Statement from Database B , we've got the following Error :
SQL> select * from ERP_USER.PS_NAP_DELV_SHIP@CRMDB.bezeqint.co.il;
select * from ERP_USER.PS_NAP_DELV_SHIP@CRMDB.bezeqint.co.il
*
ERROR at line 1:
ORA-00942: table or view does not exist
ORA-02063: preceding line from CRMDB
Thank's in advance for your help.