Dropping orphaned Synonyms
Hello,
I want to drop synonyms that are "orphaned", those synonyms whose underlining objects no longer exist. So when I go to query the dba_synonyms, it appears that the underlining are tables. Does this mean that synonyms can only be created for table objects? Thank you.
SQL> desc dba_synonyms;
Name Null? Type
----------------------------------------- -------- ----------------------------
OWNER NOT NULL VARCHAR2(30)
SYNONYM_NAME NOT NULL VARCHAR2(30)
TABLE_OWNER VARCHAR2(30)
TABLE_NAME NOT NULL VARCHAR2(30)
DB_LINK VARCHAR2(128)