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 :


Post a Comment


Twitter Delicious Facebook Digg Stumbleupon Favorites More