没啥好说的
直接上语句
alter table test enable row movement;
alter table test shrink space cascade;
alter table test disable row movement;
ANALYZE TABLE test ESTIMATE STATISTICS SAMPLE 30 PERCENT;
查表大小的语句
Select Segment_Name,Sum(bytes)/1024/1024 "字节数m",Sum(blocks) "区块数",count(*) "ext数量" From
DBA_Extents where segment_tname='TEST' Group By Segment_Name order by 3 desc;