Compress Table Partitions with Oracle HCC

SQL> ALTER TABLE MOVE PARTITION COMPRESS FOR QUERY LOW PARALLEL 8;

SQL> ALTER TABLE MOVE PARTITION COMPRESS FOR QUERY HIGH PARALLEL 8;

SQL> ALTER TABLE MOVE PARTITION COMPRESS FOR ARCHIVE LOW PARALLEL 8;

SQL> ALTER TABLE MOVE PARTITION COMPRESS FOR ARCHIVE HIGH PARALLEL 8;

Leave a Reply