alter table move & shrink space(3)

3.SHRINK SPACE

ALTER TABLE GC.R_WIP_keyparts_T SHRINK SPACE;

 

ANALYZE TABLE GC.R_WIP_KEYPARTS_T COMPUTE STATISTICS;

 

SELECT BLOCKS FROM DBA_SEGMENTS WHERE SEGMENT_NAME='R_WIP_KEYPARTS_T';

BLOCKS:137312

 

SELECT BLOCKS,EMPTY_BLOCKS FROM DBA_tableS WHERE table_NAME='R_WIP_KEYPARTS_T';

BLOCKS:136688   EMPTY_BLOCKS:624

可以看到除了HWM下的空間下降，HWM上未使用的空塊也會有回收