批改Table所属的Tablespace

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

?

?

?