ORA-00001 unique constraint (string.string) violated

ORA-00001 unique constraint (string.string) violated
 

Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
 

Action: Either remove the unique restriction or do not insert the key.

• 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';

People who read this post also read :

Posted in: Oracle Problems,Unique Constraint