Welcome to plsql4all.blogspot.com SQL, MYSQL, ORACLE, TERADATA, MONGODB, MARIADB, GREENPLUM, DB2, POSTGRESQL.

Friday, 22 April 2016

ORA-00001

            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.

If  you trying to run  INSERT or UPDATE statement which has created a duplicate value in a field restricted by a unique index


Action: 

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


Please provide your feedback in the comments section above. Please don't forget to follow.