The tablespaces we are trying to migrate is totally 10TB with 30,000 tables and 200,000 segments.
Expdp cost just one hour, but impdp cost nearly three hours!
Is there any way to speed up the process ,especially for the impdp step?
source db version: 11.2.0.3
target db version: 11.2.0.4
the parfile is as follows:
| expdp parfile |
|---|
userid='/ as sysdba' directory=DIR_XTTS_DUMP dumpfile=expdp_xtts.dmp job_name=expdp_xtts01 logfile=expdp_xtts.log transport_full_check=no transport_tablespaces=YY_DATA,YY_INX,YY_HIS CLUSTER =N |
impdp parfile
|
|---|
userid='/ as sysdba' directory=DIR_XTTS_DUMP job_name=impdp_xtts_01 EXCLUDE=TABLE_STATISTICS,INDEX_STATISTICS logfile=impdp_xtts.log dumpfile=expdp_xtts.dmp transport_datafiles='+data_dg/zjcrm/datafile/yy_data_15.xtf', '+data_dg/zjcrm/datafile/yy_inx_669.xtf', '+data_dg/zjcrm/datafile/yy_inx_9.xtf' |