how to handle this - FK constraint error while import
export of a schema -
changes made by application to the db gets committed
WHEN THE DATa is committed that time parent table has already been exported and child table ais getting exported
whole export is over giving message
export terminated successfully without warnings.
now while importing it gives
IMP-00017: following statement failed with ORACLE error 2298:
"ALTER TABLE "PRONTO_CUSTOMER_SESSION" ENABLE CONSTRAINT "FK_PRONTO_C_REF_89"
IMP-00003: ORACLE error 2298 encountered
ORA-02298: cannot validate (PRONTOMSP.FK_PRONTO_C_REF_8910_PRONTO_C) - parent keys not found
what needs to be done in the db where it is imported.
thanks in advance
find the orphans and delete them
however when I see that in an import session I always check with the origin first and see if the parent exists, if it exists then check if you have your triggers disabled during import
or use consistent=y on the export
Click Here to Expand Forum to Full Width