Range Partitioning with DBMS_REDEFINITION Package & Compression
validate index OWNER.TABLE_INDEX; SELECT opt_cmpr_count, opt_cmpr_pctsave FROM index_stats WHERE name = ‘TABLE_INDEX’; OPT_CMPR_COUNT OPT_CMPR_PCTSAVE ————– —————- 1 10 select min(LOG_DATE), …