Thanks will look into it ... And what about exclude=statistics
On 13 May 2015 18:09, "Andrew Kerber" <andrew.kerber@xxxxxxxxx> wrote:
Those all will help. The advantage from nologging is minimal if your redo
logs are adequately sized.
Sent from my iPad
On May 13, 2015, at 3:20 AM, sumit Tyagi <dba.tyagisumit@xxxxxxxxx>wrote:
performance . Please suggest on same , Can this help in performance
Hi oracle-L Team ,
One of our client has suggested the below to improve the impdp
improvement of impdp . I have checked there are several restrictions
on network_link usage .Write a script that will:
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
multiple create indexes simultaneously since we are on standard edition)
o Create the indexes in parallel (not the parallel=X option but launch
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