ORA-02298: - parent keys not found [message #507089] |
Thu, 12 May 2011 07:35 |
Database admin
Messages: 365 Registered: September 2006 Location: india
|
Senior Member |
|
|
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 |
|
ramoradba
Messages: 2457 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
|
|
|
|