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

?

?

?