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 find broken/invalid public synonyms?

WestDraytonSep 7 2011 — edited Sep 8 2011

Some of my queries produce error
"ORA-01775: looping chain of synonyms"
because public synonym still exists but referencing table have been dropped.
How to find such broken/invalid public synonyms?
System view "dba_synonyms" doesn't have column "IsThissynonymHealthyToday", so i can't collect such broken synonym listing.

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 6 2011

Added on Sep 7 2011

3 comments

12,129 views