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';