Home » RDBMS Server » Server Utilities » Datapump Import Parallel not effect in Index Creation (12.1.0.2.0,Linux x86_64)
Datapump Import Parallel not effect in Index Creation [message #638960] Fri, 26 June 2015 16:19 Go to next message
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 Go to previous messageGo to next message
John Watson
Messages: 8644
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.
Re: Datapump Import Parallel not effect in Index Creation [message #638970 is a reply to message #638961] Sat, 27 June 2015 00:46 Go to previous messageGo to next message
Michel Cadot
Messages: 68050
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Also, even with parallel 12, I am not sure the data is transferred via the database link is parallelized as much.

Re: Datapump Import Parallel not effect in Index Creation [message #639596 is a reply to message #638970] Sat, 11 July 2015 02:36 Go to previous messageGo to next message
preet_kumar
Messages: 204
Registered: March 2007
Senior Member
I know using DB link i can use impdp and import from Secondary DB but Is there an option available do remote expdp from a secondary DB ?
Re: Datapump Import Parallel not effect in Index Creation [message #639597 is a reply to message #639596] Sat, 11 July 2015 02:40 Go to previous message
Michel Cadot
Messages: 68050
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

What do you mean by "remote expdp from a secondary DB"?

Previous Topic: IMPDP got hanged
Next Topic: how to import user with network link with limitation rights
Goto Forum:
  


Current Time: Mon Dec 06 20:08:02 CST 2021