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:
well that is what i did. I dropped the user and recreated it, however the default tbs is different compared to the db from the export is coming from! Hence the need to edit the export file. Somes tables do get imported however certain rows are not inserted due to constraints!Any ideas?