| Refresh Production data to Development Schema [message #630018] |
Thu, 18 December 2014 12:14  |
preet_kumar
Messages: 204
Registered: March 2007
|
Senior Member |
|
|
Schema Refresh from Production to Development
1a. Create the user TEST and give all grants including (EXP_FULL_DATABASE,IMP_FULL_DATABASE)
2a.
impdump parfile=testimportfull.par
userid=test/test
network_link=prodlink
directory=importdir
LOGFILE=fullimport.log
CONTENT=all
EXCLUDE=STATISTICS
EXCLUDE=USER
SCHEMAS=test
Remap_tablespace=testprod:testdev
3a. Recompile for invalid objects
Now after a week i would like to refresh the Development Database from Production so i follow the below steps
1b. Disable Triggers
Disable Constraint WHERE constraint_type = 'R'
Drop Sequences
2b. Import data only.
impdump parfile=testimportcontent.par
userid=test/test
network_link=prodlink
directory=importdir
LOGFILE=importdataonly.log
CONTENT=data_only
table_exists_action=truncate
EXCLUDE=STATISTICS
EXCLUDE=USER
SCHEMAS=test
DATA_OPTIONS=skip_constraint_errors
Remap_tablespace=testprod:testdev
3b. Import the Sequence.
userid=test/test
network_link=prodlink
directory=importdir
LOGFILE=importsequence.log
CONTENT=METADATA_ONLY
SCHEMAS=test
INCLUDE=SEQUENCE
Remap_tablespace=testprod:testdev
4b. Enable Triggers
Enable Constraint WHERE constraint_type = 'R'
5b. Recompile for invalid objects
I am using the above method to refresh data from Production to our Development system which is Standard Edition so no Parallel option with impdp.
The issue is at Step 2b it takes almost 11 hours which i find very long for a total DB size of 150GB.
Could anyone suggest a faster option to refresh the development schema from production.
Thanks in advance
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
