| Faster impdp excluding Indexes and constraints [message #555455] |
Thu, 24 May 2012 04:29  |
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 |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
