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';
0 comments:
Post a Comment