ORA-01432: public synonym to be dropped does not exist

ORA-01432: public synonym to be dropped does not exist

ORA-01432: public synonym to be dropped does not exist

Cause:

The synonym specified in DROP PUBLIC SYNONYM is not a valid public synonym. It may be a private synonym.

Solution:

Correct the synonym name or use DROP SYNONYM if the synonym is not public.

Example:

DROP PUBLIC SYNONYM xyz; 

Output:

ORA-01432: public synonym to be dropped does not exist

Correct

CREATE PUBLIC SYNONYM mn123 FOR system.books;

DROP PUBLIC SYNONYM mn123;  

Output:

public synonym MN123 created.
public synonym MN123 dropped.