ORA-00001 SQL Origin: Data OSI layer 7 · Application Last updated 12 Oct 2026

ORA-00001: unique constraint (SCHEMA.PK_X) violated

An insert/update duplicated a value in a unique or primary key constraint.

Exact message you may see unique constraint violated
Seen on: SQL

Meaning

Common when sequences fall behind manually inserted ids or seeds run twice.

Common causes

  • Duplicate value
  • Sequence behind existing max(id)
  • Re-run seeds

⚡ Quick fix

  1. Use MERGE for upserts
  2. Advance the sequence past max(id)
  3. Handle as "already exists"

Detailed fix by platform

SQL

  1. ALTER SEQUENCE orders_seq RESTART START WITH 100001; -- Oracle 18c+

How to diagnose

  1. Constraint — Which one?
  2. Sequence — Behind the data?

🔧 Still not fixed?

Many errors look alike. If the steps above didn’t solve it, one of these is probably what you’re facing:

Where this error sits

Origin: Data. Errors that are often confused with or caused by this one (click to open):

1062 — MySQL ERROR 1062 (23000): Duplicate entry for key (MySQL)10622627 — SQL Server: Violation of PRIMARY KEY constraint 'x'. Cannot insert duplicate key in object 'y'. (Msg 2627) (SQL)2627515 — SQL Server Msg 515: Cannot insert the value NULL into column 'X', table 'Y'; column does not allow nulls (SQL)515ALREADY_EXISTS — API Error: Resource already exists (ALREADY_EXISTS / resource_already_exists / 409) (API)ALREADY_EXISTSAutopilot — GKE Autopilot rejected the workload: resources adjusted / violates Autopilot constraints (Google Cloud / Firebase)AutopilotDbUpdateException — DbUpdateException: An error occurred while saving the entity changes. See the inner exception for details. (.NET)DbUpdateExceptionforeign key order — Foreign key violation caused by insert order or circular references (SQL)foreign key orderORA-00018 — ORA-00018: maximum number of sessions exceeded (SQL)ORA-00018ORA-00001

Explore the map of this error Full error map →

🧠 Still stuck? Analyze your error

Paste the full message, response headers or stack trace — we'll detect the platform and point to the most likely cause.

💬 What worked for others

No tips yet — did something else fix this for you?

Share what worked for you

Tips are checked by an editor before they appear. Links are removed.