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.
Error Type: ORA
user_indexes
dictionary view to find out, which columns in the affected table are unique, eg:
select i.index_name, c.column_name, i.uniqueness
from user_indexes i, user_ind_columns c
where i.table_name = 'JOBS' --> replace this with your table_name
and c.index_name = i.index_name;
Outcome:
INDEX_NAME COLUMN_NAME UNIQUENES
------------------------------ -------------------- ---------
SYS_C0029193 JOBID UNIQUE
SYS_C0029194 JOB UNIQUE
In this example, the columns JOBID
and JOB
own a unique index. An insert or update of duplicate keys will raise ORA-00001: unique constraint ([string].[string]) violated