Home » RDBMS Server » Server Utilities » Faster impdp excluding Indexes and constraints (Oracle Linux)
Faster impdp excluding Indexes and constraints [message #555455] Thu, 24 May 2012 04:29 Go to next message
Messages: 204
Registered: March 2007
Senior Member
We need to setup a test system using data from one of the offsite customer location.The option we would like to use is impdp with network link.Please let me know if the below given step will make import faster if we exclude indexes and constraints
Import schema excluding constraints,rf_constraints,indexes with metadata only
Import schema with data only
spool ddl using dbms_metadata.get_ddl from Source for constraints,rf_constraints and indexes
execute on Destination the Index creation ddl
execute on Destination constraints and rf_constraints ddl


[Updated on: Thu, 24 May 2012 04:32]

Report message to a moderator

Re: Faster impdp excluding Indexes and constraints [message #555460 is a reply to message #555455] Thu, 24 May 2012 04:44 Go to previous message
Michel Cadot
Messages: 68342
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No, it will most likely not.

Previous Topic: tablespace management
Next Topic: Datapump import and Referential Integrity constraints
Goto Forum:

Current Time: Sun Jan 29 12:38:31 CST 2023