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;

 

Category: Uncategorized

Tags:

Leave a Reply

Article by: Shadab Mohammad