How to Resolve Oracle SQL Parent Key Not Found (ORA-02291)

Описание

In this video, we’ll explain what the ORA-02291 “parent key not found” error is, see an example, and look at how to resolve it.

This error usually happens when we try to insert data into a table.

It looks like this:

Error is: ORA-02291: integrity constraint (constraint_name) violated - parent key not found

So what does this error mean?

It means we’re trying to insert data into a child table, and there is no related record in the parent table.

If a foreign key has been set up to enforce this relationship, there needs to be a parent to insert a child that refers to it.

Watch the video to see an example of this error as well as how to resolve it.

For more information on Oracle SQL, refer to the Database Star website here:
https://www.databasestar.com/