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:
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!
09-14-2006, 09:47 AM
why did you use an indexfile as opposed to just letting the import do everything you want?
The import wouldnt enable constraints till the end
09-14-2006, 09:51 AM
I used the indexfile because the user i am importing too has a different tablespace. Once i edited it, i ran the script to create the empty tables et all. Is there another way of doing this?
09-14-2006, 10:38 AM
yes, create the user up front - set up the default tablespaces there and away you go
09-14-2006, 11:18 AM
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?
09-14-2006, 11:28 AM
there is no need to edit anything, the tables will go into the default tablespace of the new user
09-14-2006, 12:31 PM
Davey is right, but if it's that much of pain to have objects in the users default tablespace, why don't you just create new tablespaces with the same names that you had on the old database?
I'm struggling to see the problem here...
09-14-2006, 12:38 PM
The problem i have here is that the users have different tablespaces assigned to them and has to remain this way. During the import i am getting:
IMP-00019: row rejected due to ORACLE error 2291
IMP-00003: ORACLE error 2291 encountered
ORA-02291: integrity constraint (FEBSTEST.RPT_PARAMETER_MAP_REPORT_ID_FK) violat
on sevaral of the tables. Hence i that tables rows are not imported! Any solutions guys?
Thanks in advance
09-14-2006, 12:43 PM
No really...davey23uk has already provided a solution to your problem. One question though, do any of the tables you are importing have LOBS? If so, you'll need to precreate these tables.