Oracle error

ORA-02291

ORA-02291: integrity constraint (%s.%s) violated - parent key not found

What usually causes it

A child row references a parent key value that doesn't exist.

What to check first

Insert the parent first, or correct the foreign key value.

Scripts that help

• Disabled constraints and triggersConstraints and triggers someone switched off, often for a data load, and never switched back on.

Open in the error lookupOracle's reference