Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to get the error message which causes Synonym Invalid?

527542Dec 27 2007 — edited Dec 29 2007
Hi,

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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 26 2008
Added on Dec 27 2007
5 comments
909 views