收縮表空間 for Oracle 10g

---------------------------------
收縮表空間
---------------------------------
1.檢視錶的使用狀況
select sum(bytes)/1024/1024/1024 Gb from user_segments where segment_name='WIP_WO';

2.開啟行遷移功能
alter table wip_wo enable row movement;

3.整理表空間內的碎片
alter table wip_wo shrink space compact;

4.收縮表空間
alter table wip_wo shrink space;

5.檢視收縮後的表空間
SQL> select sum(bytes)/1024/1024 M from user_segments where segment_name='WIP_WO';

6.收縮index的空間
SQL> alter index WIP_WO_INX1 shrink space;

Index altered.

Elapsed: 00:00:00.52
SQL> alter index WIP_WO_INX2 shrink space;

Index altered.

Elapsed: 00:00:00.82
SQL> alter index WIP_WO_INX3 shrink space;

Index altered.

Elapsed: 00:00:02.57
SQL> alter index WIP_WO_PK1 shrink space;

Index altered.

Elapsed: 00:00:00.60
SQL> alter index WIP_WO_UN1 shrink space;

注：
如果table很大，在收縮表空間時會產生大量的archivelog[@more@]

參考：http://hi.baidu.com/bailang3106/blog/item/6f2785eefdd2a4212cf5342d.html

http://black4371.blog.163.com/blog/static/3202390220104141941895/