Partition Table and Exadata Hybrid Columnar Compression (EHCC)
- by Bandari Huang
Create EHCC table
CREATE TABLE ... COMPRESS FOR [QUERY LOW|QUERY HIGH|ARCHIVE LOW|ARCHIVE HIGH];
select owner,table_name,compress_for DBA_TAB_SUBPARTITIONS where compression = ‘ENABLED';
Convert Table/Partition/Subpartition to EHCC
Compress Table&Partition&Subpartition to EHCC:
ALTER TABLE table_name…