Synonyms for Remote DB [message #682800] |
Fri, 20 November 2020 08:59 |
muktha_22
Messages: 527 Registered: December 2009
|
Senior Member |
|
|
Hello All,
I am facing the problem of accessing procedure of remote server by creating synonyms, kindly help me.
1) Created DBLINK from Local DB to REMOTE DB.
2) Able access all the objects, except PROCEDURE.
3) Remote DB is having a Procedure PR1
4) From Local DB, we are accessing it by creating a SYNONYM SYN1
It was working fine suddenly showing such OBJECT is not existing.
We tried to recreate the synonym, it get created but showing the same error.
ORA-00942 table or view doesnt exist
ORA-02063: preceding line from (link name)
We confirmed the availablity of that PROCEDURE in the REMOTE DB.
Thanks and Regards
Muktha
|
|
|
|
Re: Synonyms for Remote DB [message #682803 is a reply to message #682800] |
Fri, 20 November 2020 09:49 |
|
BlackSwan
Messages: 26766 Registered: January 2009 Location: SoCal
|
Senior Member |
|
|
You don't get ORA-00942 table or view doesnt exist from "missing" Procedure.
It appears that you are mis-reporting reality.
use COPY & PASTE so we can see what you do & hw Oracle responds.
|
|
|