Home » RDBMS Server » Server Utilities » Faster impdp excluding Indexes and constraints (Oracle 10.2.0.5 Linux)
Faster impdp excluding Indexes and constraints [message #555455] Thu, 24 May 2012 04:29 Go to next message
preet_kumar
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
Steps
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

Regards

[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: 67750
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No, it will most likely not.

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


Current Time: Tue Mar 02 11:53:04 CST 2021