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博客 ” ，链接：http://blog.itpub.net/23490498/viewspace-676934/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/23490498/viewspace-676934/