Adsense Ad

Tuesday 23 May 2017

Oracle: ORA-01433 Error Message

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.

No comments: