EXPDP
============
=> Give more parallel as per allocated CPU
=> Exclude stats
IMPDP
===========
=> create SQL file for Triggers and Indexes and modify parallel 1 to "parallel *" (as per your CPU)
=> Import metadata only (exclude index,stats)
=> Generate script to disable PK,FK constraints ( Do not generate script for check constraint)
=> Disable PK,FK constraints ( Do not disable check constraint)
=> import data_only ( parallel depends on CPU and dump files)
=> Create index and trigger in parallel (this will generate PK index also)
=> enable PK and FK constraints
=> gather stats (or import stats)
============
=> Give more parallel as per allocated CPU
=> Exclude stats
IMPDP
===========
=> create SQL file for Triggers and Indexes and modify parallel 1 to "parallel *" (as per your CPU)
=> Import metadata only (exclude index,stats)
=> Generate script to disable PK,FK constraints ( Do not generate script for check constraint)
=> Disable PK,FK constraints ( Do not disable check constraint)
=> import data_only ( parallel depends on CPU and dump files)
=> Create index and trigger in parallel (this will generate PK index also)
=> enable PK and FK constraints
=> gather stats (or import stats)
No comments:
Post a Comment