Imprt (2291)

[netbar]

Hi,

I did an export but found some extents to be too large for the tablspaces ther were going too, therfore I used an indexfile to precreate the tables, so I have all the table precreated with no data, now I try to use the original import with ignore=y, howvever it fails with the following errors

IMP-00019: row rejected due to ORACLE error 2291
IMP-00003: ORACLE error 2291 encountered
ORA-02291: integrity constraint (TEST.R_638) violated - parent key not found

I have tried the import with constraints=n

Thanks in advance...

[kgb]

When you make an export use CONSISTENT=Y clause