Import Error

[dsuva]

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

[Mr.Hanky]

What level import are you doing? Full, table, schema???

MH

[dsuva]

table level export

[Mr.Hanky]

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