Hi oracle-L Team ,
One of our client has suggested the below to improve the impdp performance
. Please suggest on same , Can this help in performance improvement of
impdp . I have checked there are several restrictions
on network_link usage .
1. Use network_link with impdp instead of export/copy/import
2. Replace tables but exclude indexes and constraints
3 Use indexfile to generate the index/constraint creation script and Write
a script that will:
o Create the indexes in parallel (not the parallel=X option but launch
multiple create indexes simultaneously since we are on standard edition)
o Increase the sort_area_size for the session before creating the indexes
o Change the constraint create to use novalidate
o Create the indexes with nologging.
--
--
BR
Sumit
