Hi all!

I came across in a manual about this.But still have some doubt regarding the clause Parallel 5 degree used with UPDATE GLOBAL INDEXES.

Could anybody explain the significance of it.

ALTER TABLE SALES
EXCHANGE PARTITION SALES_Q1_2000
TABLE SALES_2000
UPDATE GLOBAL INDEXES
PARALLEL(DEGREE 4);

What would be the state of Local as well as Global Indexes in terms of USABLE,UNUSABLE status:

a).Will the local indexes be in a usable state but global indexes in unusable state.
b).Will the local indexes be in a usable state but global indexes in unusable state considering PARALLEL(DEGREE 4)
is maintained.
c)..Will the local indexes be in a usable state but global indexes in unusable state considering PARALLEL(DEGREE 4)
is not maintained.

Thanks & Regards,

Amit.