Oracle / PLSQL: ORA-01433 Error Message
Learn the cause and how to resolve the ORA-01433 error message in Oracle.
Description
When you encounter an ORA-01433 error, the following error message will appear:
- ORA-01433: synonym to be created is already defined
Cause
You tried to create a synonym whose name is the same as an existing synonym, table, view, or cluster.
Resolution
The option(s) to resolve this Oracle error are:
Option #1
Select a name that has not already been used by a synonym, table, view, or cluster and then rerun your CREATE SYNONYM command with this new name.
You can find the object with the same name as the synonym that you tried to create with the following SQL statement:
SELECT *
FROM all_objects
WHERE object_type in ('SYNONYM','TABLE','VIEW','CLUSTER')
AND object_name = 'NAME';
where NAME is the name of the synonym that you tried to create.
Advertisements