Database Administration (MOSC)

MOSC Banner

Synonym Does Not Exist, But It Does

edited Dec 29, 2021 7:08PM in Database Administration (MOSC) 4 commentsAnswered ✓

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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center