I have done a FULL (full=y) export on a db. For the import i need to import into a schema. On the second db, i have dropped the user (cascade) and recreated the user with an empty schema. Now i generated the import with the indexfile option to generate the ddl:
imp system file=expfull.dmp fromuser=test touser=test indexfile=index.sql statistics=none ignore=y
In the index file i removed all the REM comments and replaced the default tablespace with the default tablespace for the user on the second db. I ran the import:
imp system file=expfull.dmp fromuser=test touser=test statistics=none ignore=y
I got the following errors (one of many) duringof the import:
Column 1 3100
Column 2 Pieter Breughelstraat 837
Column 3 3029SK
Column 4 Utrecht
Column 5 Utrecht
Column 6 NL
IMP-00019: row rejected due to ORACLE error 2291
IMP-00003: ORACLE error 2291 encountered
ORA-02291: integrity constraint (NIK.LOC_C_ID_FK) violated - parent key not foun
Now the questions i have are:
Have I done it the wrong way?
Do contraints have to be disabled?
Do i do this by removing the 'enable constraints' bit in the index file generated?
Any help will be much appreciated!
Click Here to Expand Forum to Full Width