Learn the purpose and how to resolve the ORA-01434 error message in Oracle.
When you stumble upon an ORA-01434 error, the following error message will appear:
ORA-01434: private synonym to be dropped does not exist
You tried to drop a non-public synonym that does no longer exist.
The option(s) to resolve this Oracle error are:
Check to make positive that you unique the personal synonym name correctly.
Your synonym may additionally be a public synonym, not a personal synonym.
You can discover a checklist of all personal synonyms with the following SQL statement:
SELECT * FROM all_synonyms WHERE owner <> 'PUBLIC';
To discover out if your synonym was created as a public synonym, run the following SQL statement:
SELECT * FROM all_synonyms WHERE owner = 'PUBLIC' AND synonym_name = 'SYNONYM_NAME';
where SYNONYM_NAME is the name of the synonym that you are looking for.
If your synonym was created as a public synonym, you can drop it with the following command:
DROP PUBLIC SYNONYM synonym_name;
where synonym_name is the title of the public synonym that you desire to drop.