通过（在线重定义）方式在线变更表的存储表空间

–创建源表
create table t.ttt3 as select * from scott.emp;
–创建中间表
create table t.TTT_INT tablespace newtps as select * from t.ttt3;
–查看是否可以在线从定义
EXEC DBMS_REDEFINITION.CAN_REDEF_TABLE(‘T’, ‘TTT3’,2);

–查看对象copy过程错误
–select * from DBA_REDEFINITION_ERRORS;
查看对象注册情况
–select * from DBA_REDEFINITION_OBJECTS
–开始在线重定义
exec DBMS_REDEFINITION.START_REDEF_TABLE(‘T’, ‘TTT3’,‘TTT_INT’,’’,2);
–同步数据
exec dbms_redefinition.SYNC_INTERIM_TABLE(‘T’, ‘TTT3’,‘TTT_INT’);
–完成在线重定义
exec dbms_redefinition.FINISH_REDEF_TABLE(‘T’, ‘TTT3’,‘TTT_INT’);
–删除中间表
drop table TTT_INT cascade constraints;