HWM
-
编辑 删除
降低HWM的方法之shrink
命令：alter table <table_name> shrink space前提：允许行移动，alter table <table_name> enable row movement且不再system表空间测试：SQL> create table test tablespace users as select * from dba_ob...
-
编辑 删除
降低HWM的方法之move
1.move表重建索引 alter table <table_name> move alter index <index_name> rebuild online tablespace <tablespace_name>2.SQL> create table test as select * from db...
