Oracle Error ORA-00001 – unique constraint (string.string) violated

Oracle Error Message

ORA-00001 – unique constraint (string.string) violated

Reason for the Error

An UPDATE or INSERT statement attempted to insert a duplicate key. For Trusted Oracle configured in DBMS MAC mode, you may see this message if a duplicate entry exists at a different level.

The error ORA-00001 is frequently seen when a software tries to insert a “duplicate” row in a table, and when a unique constraint is violated the row will not be added to the table

Solution

Name of constraint violated will be included in error message. The column(s) on which the unique constraint is specified can be identified using that constraint name.

You will need to either remove the unique restriction or do not insert the key.