Enable constraints in parallel
709382Sep 1 2010 — edited Sep 1 2010Hi,
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