Oracle 11.2.0.3
I am moving partitions and indexes to a new tablespace.
The command submitted is
ALTER INDEX REBUILD PARTITION PX PARAMETERS(replace storage S_D2) PARALLEL 32;
The SQL that actually runs has the PARALLEL 32 replaced with NOPARALLEL
Any ideas why?
Before the ALTER INDEX I move the Partition using
ALTER TABLE T1 MOVE PARTITION PX TABLESPACE D2 UPDATE INDEXES PARALLEL 32;
DEGREE for both the table and index is still 1.
Regards