DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: how to handle this - FK constraint error while import

  1. #1
    Join Date
    Jan 2004
    Location
    Washington , USA
    Posts
    132

    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"
    "10_PRONTO_C""
    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

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    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

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    or use consistent=y on the export

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width