Fixes for ORA-02298 - Parent Key Not Found & Invalid Objects after Imports?
orchidNov 8 2011 — edited Nov 10 2011Greetings,
Our DBA has been doing the refresh of my test schema with the Production data and objects without any problems since I started working here in 2008. But, this afternoon, after the refresh of my test schema, I found there are a total of 6 invalid packages, 2 procedures and about 76 invalid views. I was able to compile the invalid views okay, but several attempts all failed in trying to recompile the invalid packages and procedures.
The following errors are excerpted from the DBA’s import log:
About to enable constraints...
IMP-00017: following statement failed with ORACLE error 2298:
"ALTER TABLE "DWR_EQUIP" ENABLE CONSTRAINT "DWR_EQUIP_DWR_FK""
IMP-00003: ORACLE error 2298 encountered
ORA-02298: cannot validate (OWNER.DWR_EQUIP_DWR_FK) - parent keys not found
IMP-00017: following statement failed with ORACLE error 2298:
"ALTER TABLE "DWR_LAB" ENABLE CONSTRAINT "DWR_LAB_DWR_FK""
IMP-00003: ORACLE error 2298 encountered
ORA-02298: cannot validate (OWNER.DWR_LAB_DWR_FK) - parent keys not found
IMP-00017: following statement failed with ORACLE error 2298:
"ALTER TABLE "DWR_MATL" ENABLE CONSTRAINT "DWR_MATL_DWR_FK""
IMP-00003: ORACLE error 2298 encountered
ORA-02298: cannot validate (OWNER.DWR_MATL_DWR_FK) - parent keys not found
Import terminated successfully with warnings.
Are these errors related to the invalid packages and/or procedures? What are the impacts to my test schema from these errors? How do I recompile the 6 invalid packages and 2 invalid procedures? How to make invalid objects to compile ok?
Thanks in advance for any/all the help.