Skip to Main Content

Oracle Database Discussions

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!

Enable constraints in parallel

709382Sep 1 2010 — edited Sep 1 2010
Hi,

I am in the process of seeding up import.
In our Datawarehouse environment enabling constrainta during import takes lot of time..To improve the performance of this step, i created constraints script seperately added parallelism in all commands (eg: alter table x1 add constraint xc1 .....enable parallel 4;)

i changed degree os paralllelism of each table to 4 , i included following command at the start of the script.

alter session force paralllel ddl parallel 4;

Still constraints are not being enabled in parallel.
How can i make these constraints enable step uses paralllelism.
Is there is any other way to improve enable constraint performence during import.

We are on 10.2.0.4 ...sun solaris 10 and we are using data pump.

Thanks
Pramod
This post has been answered by BelMan on Sep 1 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 29 2010
Added on Sep 1 2010
1 comment
986 views