ORA-01434: private synonym to be dropped does not exist

ORA-01434: private synonym to be dropped does not exist

ORA-01434: private synonym to be dropped does not exist

Cause:

A DROP SYNONYM statement specified a synonym that does not exist. Existing synonym names may be listed by querying the data dictionary.

Solution:

Specify the name of an existing synonym in the DROP SYNONYM statement.




Example:

DROP SYNONYM xyz; 

Output:

ORA-01434: private synonym to be dropped does not exist

Correct

CREATE SYNONYM abc123 FOR system.books;

DROP SYNONYM abc123; 

Output:

synonym ABC123 created.
synonym ABC123 dropped.