tech on the net
Home About Us Feedback Site Map

Microsoft

Access Excel Word

Database

SQL Oracle / PLSQL SQL Server MySQL MariaDB PostgreSQL

Web Development

HTML CSS Color Picker

Language

C Language

More

ASCII Table Linux UNIX Java Clipart Joke of the Moment
Share this page:

Oracle/PLSQL: ORA-02298

Learn the cause and how to resolve the ORA-02298 error message in Oracle.

Description

When you encounter an ORA-02298 error, the following error message will appear:

  • ORA-02298: cannot enable name - parent keys not found

Cause

You tried to execute an ALTER TABLE ENABLE CONSTRAINT command, but it failed because your table has orphaned child records in it.

Resolution

The option(s) to resolve this Oracle error are:

Option #1

Remove the orphaned child records from the child table (foreign key relationship), and then re-execute the ALTER TABLE ENABLE CONSTRAINT command.

Option #2

Create the missing parent records in the parent table (foreign key relationship), and then re-execute the ALTER TABLE ENABLE CONSTRAINT command.

Learn more about foreign keys.