IMPDP with constraints [message #351876] |
Fri, 03 October 2008 09:50 |
spettroelica
Messages: 1 Registered: October 2008
|
Junior Member |
|
|
Hi at all,
I'm a newbie in Oracle datapump and I've a question.
I need to migrate a database from a server to another server.
I used
expdp system/password@SID directory=EXP_DIR SCHEMAS=schema1,schema2 dumpfile=exp_all_schemas.dmp logfile=exp_all_schemas.log
to export data from first server.
Now on the second server I think to use
impdp system/password@SID directory=IMP_DIR SCHEMAS=schema1,schema2 dumpfile=exp_all_schemas.dmp logfile=imp_all_schemas.log
but in schema1 I've some tables with foreign keys to other tables of schema2.
I think that the import will returns some errors because it import firstly schema1 and when it try to create foreign keys, while schema2 is still not imported, it fails.
How can I solve this problem?
Many Thanks.
|
|
|
|