Datapump Import Parallel not effect in Index Creation [message #638960] |
Fri, 26 June 2015 16:19 |
preet_kumar
Messages: 204 Registered: March 2007
|
Senior Member |
|
|
I am using Datapump impdp with Network Link and also parallel=12.
The table are imported in an hour but the Index creation takes too long time.I again ran a impdp only including Index with sqlfile option and in the output i notice the Index creation statement contains Paralle1 1.
Does it mean that using parallel option with impdp does not create Indexes in parallel and i need to run the impdp in 2 steps first excluding index and then include Index and get a sqlfile which i edit and modify the Parallel option and run the sqlfile to create the Index ?
|
|
|
Re: Datapump Import Parallel not effect in Index Creation [message #638961 is a reply to message #638960] |
Fri, 26 June 2015 16:50 |
John Watson
Messages: 8951 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
I always set all indexes to NOLOGGING before the export. This speeds up the import consideraby. I usually set all constraints to ENABLE NOVALIDATE, which is even better.
But network link is always dreadfully slow, because it uses the external table path, not direct path. Usually faster not to use it.
|
|
|
|
|
|