Synonym Does Not Exist, But It Does
I'm trying to drop a synonym as sysdba. It says
ORA-01432: public synonym to be dropped does not exist
But the dba_synonyms says it is PUBLIC and exists. Everything I've researched says "it is private, not public", but this says the owner is PUBLIC
SELECT SYNONYM_NAME,OWNER,TABLE_OWNER FROM DBA_SYNONYMS WHERE UPPER(SYNONYM_NAME) = 'ADDRESS_BOOK_TB' / SYNONYM_NAME OWNER TABLE_OWNER ------------------------------ ------------------------------ ------------------------------ Address_Book_tb PUBLIC SALES DROP PUBLIC SYNONYM Address_Book_tb; DROP PUBLIC SYNONYM Address_Book_tb * ERROR at line 1: ORA-01432: public synonym to be dropped does not exist
Same happens when I try uppercase: DROP PUBLIC SYNONYM ADDRESS_BOOK_TB;