ORA error

ORA-00001

ORA-00001: unique constraint (string.string) violated

Quick fix

Cause: An INSERT or UPDATE tried to store a value that already exists in a column (or column set) covered by a PRIMARY KEY or UNIQUE constraint or unique index. The two strings in the message are the owner and name of that constraint.
Fix: Find the constraint and its columns in DBA_CONS_COLUMNS, then either skip the duplicate row, update the existing row instead (MERGE), or take the key from a sequence / identity column instead of computing it.

SELECT column_name, position
  FROM dba_cons_columns
 WHERE owner = 'OWNER' AND constraint_name = 'CONSTRAINT_NAME'
 ORDER BY position;

ORA-00001: unique constraint violated – Inserting duplicate value into a UNIQUE/PK column.

Database