ORA-02298: - parent keys not found [message #507089] |
Thu, 12 May 2011 07:35 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Database admin
Messages: 365 Registered: September 2006 Location: india
|
Senior Member |
![bala_mech2004](/forum/theme/orafaq/images/yahoo.png) ![fgdgs](/forum/theme/orafaq/images/jabber.png)
|
|
Hi,
I received the below error while importing the dump file.
IMP-00017: following statement failed with ORACLE error 2298:
"ALTER TABLE "tab1" ENABLE CONSTRAINT "TSK_FK""
IMP-00003: ORACLE error 2298 encountered
ORA-02298: cannot validate (bala.TSK_FK) - parent keys not found
can anyone tell me how to resolve this error?
Thanks
[Updated on: Thu, 12 May 2011 08:04] by Moderator Report message to a moderator
|
|
|
Re: IMP-00017 [message #507090 is a reply to message #507089] |
Thu, 12 May 2011 07:36 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/136607.jpg) |
ramoradba
Messages: 2456 Registered: January 2009 Location: AndhraPradesh,Hyderabad,I...
|
Senior Member |
|
|
Quote:ORA-02298: cannot validate (bala.TSK_FK) - parent keys not found
Its failed ..because dependent commands were also failed.
Quote:parent keys not found
check the log.
Quote:Error:
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.
Action:
The options to resolve this Oracle error are:
Remove the orphaned child records from the child table (foreign key relationship), and then re-execute the ALTER TABLE ENABLE CONSTRAINT command.
Create the missing parent records in the parent table (foreign key relationship), and then re-execute the ALTER TABLE ENABLE CONSTRAINT command.
ORA-02298:
cannot validate (string.string) - parent keys not found
Cause: an alter table validating constraint failed because the table has orphaned child records.
Action: Obvious
Sriram
[Updated on: Thu, 12 May 2011 08:35] by Moderator Report message to a moderator
|
|
|
|