Oracle® Database 8i | 9i | 10g | 11g | 12c | 18c | 19c Error Codes

Information for Database Error Code ORA-00001: unique constraint ([string].[string]) violated
Oracle® Database Error ORA-000012/4

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

Tip:

Check for unique constraints in the 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

Oracle® Database Error Codes 8i | 9i | 10g | 11g | 12c | 18c | 19c

Record: 1/1

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners

Oracle: Registered trademark of Oracle