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.
