Oracle DBA, How To, Error, Cause and Action

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. For Trusted Oracle configured in DBMS MAC mode, you may see this message if a duplicate entry exists at a different level.



Action:


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

No comments:

Post a Comment

Thanks for your comment.

Subscribe to: Post Comments (Atom)