How to get the error message which causes Synonym Invalid?
527542Dec 27 2007 — edited Dec 29 2007Hi,
I created a synonym in USER_B for a table in USER_A.
I have given all priveleges to USER_B from USER_A.
I created a package. In that I am using this synonym. Its working fine.
Today I have seen that.. the synonym is showing as invalid.
Even I recompiled the synonym. But its still showing as Invalid in PL/SQL developer.
Here I would like to see the error message which cause the synonym invalid.
How can I see the error message.?
Thank you,
Regards,
Gowtham Sen.