Home » RDBMS Server » Server Utilities » ORA-02298: - parent keys not found (10.2.0.2.0,unix)
ORA-02298: - parent keys not found [message #507089] Thu, 12 May 2011 07:35 Go to next message
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 Go to previous messageGo to next message
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

Re: IMP-00017 [message #507098 is a reply to message #507090] Thu, 12 May 2011 08:00 Go to previous message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member



Thanks you Sriram for your explanation.


Previous Topic: SQL Loader - Excel file different column order format
Next Topic: Hot backup of tablespaces
Goto Forum:
  


Current Time: Thu Mar 28 09:20:07 CDT 2024