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...
When you make an export use CONSISTENT=Y clause
Click Here to Expand Forum to Full Width