Oracle Table Reorganization(shrink space)
Table Reorganization(shrink space)
標籤: Oracle
Propose / 目標
1.move down the HWM (表格如果常異動 insert/update/delete,則會產生許多碎片)
2.releases unused extents.
Howto:
alter table mytable enable row movement;
alter table mytable shrink space compact <cascade>;
alter table mytable shrink space <cascade>;
Table Reorganization
1.static