Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

impdp and parallel index creation

785360Aug 20 2010 — edited Mar 21 2011

This may be a very basic question for most of you but..

Can anyone explain whether running impdp with parallel=n will lead to creation of 1 index at a time with n PX processes (suppose I have n dump files)? Or will it create n indexes at a time each with n PX processes? Does index DDL (parallel 1) matter to impdp parallel=n option?

How will the result differ if I have only 1 dump file? Will impdp use n processes to read 1 dump file?

I am talking about 11gr2 EE.

This post has been answered by Dean Gagne-Oracle on Aug 20 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 18 2011

Added on Aug 20 2010

#11g, #database-key-features, #export-import-sql-loader-external-tables, #index

6 comments

6,680 views