ORACLE分区表缩表

ANALYZE TABLE MRDATA.T_AM_HOLD_PAYYOFF_TAG ESTIMATE STATISTICS;

SELECT table_name,partition_name,
    ROUND (blocks * 8 / 1024 , 2) "物理大小(MB)",
    ROUND (num_rows * avg_row_len / 1024 / 1024, 2) "实际数据大小(MB)"
  FROM dba_tab_partitions WHERE UPPER(table_name)='T_AM_HOLD_PAYYOFF_TAG'
  ORDER BY partition_name DESC;

ALTER TABLE MRDATA.T_AM_HOLD_PAYYOFF_TAG ENABLE ROW MOVEMENT;

ALTER TABLE MRDATA.T_AM_HOLD_PAYYOFF_TAG MODIFY PARTITION P_202301 SHRINK SPACE;

ALTER TABLE MRDATA.T_AM_HOLD_PAYYOFF_TAG DISABLE ROW MOVEMENT;