ORA error

ORA-02291

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

Quick fix

Cause
An INSERT or UPDATE on a child table set a foreign-key column to a value that does not exist in the parent table's primary or unique key.
Fix
Insert the parent row first (or in the same transaction, before the child), correct the foreign-key value, or check which parent table the constraint references in DBA_CONSTRAINTS (R_CONSTRAINT_NAME).

Where it comes up

Related error codes