Home » SQL & PL/SQL » SQL & PL/SQL » ORA-02298: cannot validate (PL_REM_FK_ES_EMP) - parent keys not found
ORA-02298: cannot validate (PL_REM_FK_ES_EMP) - parent keys not found [message #302238] Mon, 25 February 2008 00:44 Go to next message
Messages: 37
Registered: February 2008
Location: pakistan

I disabled some constraints. But now, when I try to enable them then I get the error:

ORA-02298: cannot validate (PL_REM_FK_ES_EMP) - parent keys not found.

please guide me to resolve this problem.

Re: ORA-02298: cannot validate (PL_REM_FK_ES_EMP) - parent keys not found [message #302243 is a reply to message #302238] Mon, 25 February 2008 00:54 Go to previous message
Michel Cadot
Messages: 63917
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Find all rows that have not the parent key and delete them or do what you want with them. For instance, "select ... where not exists ..." or "where not in ..."

You can also use an exception table when you enable the constraint.

Previous Topic: table deadlock
Next Topic: How do I fire trigger with sequnce value condition?
Goto Forum:

Current Time: Mon Oct 24 15:28:29 CDT 2016

Total time taken to generate the page: 0.11402 seconds