修改Table所属的Tablespace
alter table table1 move tablespace test2;
然后rebuild table1上的indexes.
select 'alter table '||T.owner||'.' || table_name || ' move tablespace OWNER_TAB;' from ALL_tables T WHERE T.owner = 'OWNER'; select 'alter index '||T.owner||'.' || T.index_name || ' rebuild tablespace OWNER_IDX;' from ALL_INDEXES T WHERE T.owner = 'OWNER';
?
?
?
