shrink table
1. 查表的大小
SET lines 80
col segment_name format a35;
SELECT segment_name,SUM(BYTES)/1024/1024 SUM
FROM dba_segments
WHERE segment_name IN (SELECT table_name
FROM dba_tables
WHERE segment_name='WMS_FG_M2_PANEL_SHIPPING')
AND BYTES/1024/1024>=50
GROUP BY segment_name
ORDER BY SUM DESC;
EXEC Show_Space('WMS_FG_M2_PANEL_SHIPPING','auto','T','Y'); --保存输出
2. Shink table&Rebuild index
ALTER TABLE ASRS.WMS_FG_M2_PANEL_SHIPPING ENABLE ROW MOVEMENT;
ALTER TABLE ASRS.WMS_FG_M2_PANEL_SHIPPING SHRINK SPACE;
--rebuild index
3. 再查表的大小
SET lines 80
col segment_name format a35;
SELECT segment_name,SUM(BYTES)/1024/1024 SUM
FROM dba_segments
WHERE segment_name IN (SELECT table_name
FROM dba_tables
WHERE segment_name='WMS_FG_M2_PANEL_SHIPPING')
AND BYTES/1024/1024>=50
GROUP BY segment_name
ORDER BY SUM DESC;
EXEC Show_Space('WMS_FG_M2_PANEL_SHIPPING','auto','T','Y'); --保存输出
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/23490498/viewspace-676934/ ，如需转载，请注明出处，否则将追究法律责任。
