Version 11.2.0.4
I am trying to compress data in partitions to save on disk usage. The command I am using
The Table and Partitions are created with COMPRESS FOR QUERY HIGH
After completing the Inserts to the Load Table the Data is Not Compressed
1. Create Working_Table
2. SWAP Load Partition into Working_Table
3. Create Indexes on Working_Table
4.Exchange Working_Table into Main_Table
5. ALTER TABLE MAIN_TABLE MOVE PARTITION <SYS_P444> UPDATE INDEXES;
This automatically generates
ALTER INDEX<INDEX_NAME> REBUILD PARTITION <PARTITION_NAME> NOPARALLEL.
How do I make the NOPARALLEL to PARALLEL 48? The time to rebuild the indexes is way too long.
I tried adding PARALLEL 48 after the UPDATE INDEXES ut that only generated multiple sessions for the ALTER TABLE
Regards