Oracle/PLSQL: ORA-00001 Error
ORA-00001: unique constraint (constraint_name) violated
Cause of Error
You tried to execute an INSERT or UPDATE statement that has created a duplicate value in a field restricted by a unique index.
The option(s) to resolve this Oracle error are:
Drop the unique constraint.
Change the constraint to allow duplicate values.
Modify your SQL so that a duplicate value is not created.
If you are not sure which unique constraint was violated, you can run the following SQL:
select distinct table_name from all_indexes where index_name = 'CONSTRAINT_NAME';
In our example (see picture above), our constraint name would be SYS_C002459 and we would execute the following SQL:
select distinct table_name from all_indexes where index_name = 'SYS_C002459';
This would return the name of the table whose unique constraint we violated.