Home » RDBMS Server » Server Utilities » IMPDP with constraints (10g Red Hat Linux)
IMPDP with constraints [message #351876] Fri, 03 October 2008 09:50 Go to next message
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.
Re: IMPDP with constraints [message #351935 is a reply to message #351876] Fri, 03 October 2008 14:57 Go to previous message
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Try this

Previous Topic: SQL Loader: finished with process status 2
Next Topic: exp hangs at cluster definitions (merged)
Goto Forum:

Current Time: Mon Jan 23 13:35:50 CST 2017

Total time taken to generate the page: 0.07389 seconds