Import Error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Import Error

  1. #1
    Join Date
    Sep 2000
    Location
    Calcutta / Ahmedabad, India
    Posts
    137

    Import Error

    Hi,

    I have been importing a 20GB dump file. After running for 2 days it is now giving these errors. i can see that there are some refrential constraint violation. But does that mean that those particular rows won't get imported. Isn't constraint enabling done at the end of the import, and if the condition doesn't match then that particular constraint remains disabled.
    ------------------------------------------------------------------

    IMP-00019: row rejected due to ORACLE error 2291
    IMP-00003: ORACLE error 2291 encountered
    ORA-02291: integrity constraint (SYSADM.OT_XACT) violated - parent key not found
    Column : 8490607
    Column : 7
    Column : ------------------------------------------------------------------

    Thanks
    Suvashish

  2. #2
    Join Date
    Jan 2001
    Posts
    3,131
    What level import are you doing? Full, table, schema???

    MH
    I remember when this place was cool.

  3. #3
    Join Date
    Sep 2000
    Location
    Calcutta / Ahmedabad, India
    Posts
    137
    table level export
    Suvashish

  4. #4
    Join Date
    Jan 2001
    Posts
    3,131
    Well if the structures are in place that may explain it since Oracle will import the tables in alphabetical order, kinda blows a hole in your R.I. (Referential Integrity)

    Now that I think about it at the table level I think Oracle will do the same, create the table, then import the data, one at a time, alphabetically. I'm pretty sure about this, not positive, check the import log file (you do have one, don't you?) and see.

    Can you import CONSTRAINTS=N and then import the R.I. later?
    OR, if the R.I is in place, spool a file to disable the constraints, import, then re-enable them. You MUST be sure that your data is good however.

    MH
    I remember when this place was cool.

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