[Oracle] oracle普通表转化为分区表的方法

BEGIN
DBMS_REDEFINITION.CAN_REDEF_TABLE('SOCTT','EMP',DBMS_REDEFINITION.CONS_USE_PK);
END;
/
PL/SQL procedure successfully completed.显示的是没有问题的

CREATE TABLE SCOTT.EMP_1
(
 EMPNONUMBER(4),
 ENAMEVARCHAR2(10 BYTE),
 JOBVARCHAR2(9 BYTE),
 MGRNUMBER(4),
 HIREDATEDATE,
 SALNUMBER(7,2),
 COMMNUMBER(7,2),
 DEPTNONUMBER(2)
)
PARTITION BY RANGE (DEPTNO)
(
 PARTITION EMP_A1 VALUES LESS THAN (20),
 PARTITION EMP_A2 VALUES LESS THAN (30),
 PARTITION EMP_A3 VALUES LESS THAN (40),
 PARTITION EMP_A4 VALUES LESS THAN (50),
 PARTITION EMP_A5 VALUES LESS THAN (60)
   )

EXEC DBMS_REDEFINITION.START_REDEF_TABLE('SCOTT', 'EMP', 'EMP_1');

BEGIN 
 DBMS_REDEFINITION.SYNC_INTERIM_TABLE('SCOTT', 'EMP', 'EMP_1');
END;
/

DECLARE
num_errors PLS_INTEGER;
BEGIN
DBMS_REDEFINITION.COPY_TABLE_DEPENDENTS('SCOTT', 'EMP','EMP_1',
DBMS_REDEFINITION.CONS_ORIG_PARAMS, TRUE, TRUE, TRUE, TRUE, num_errors);
END;
/

select object_name, base_table_name, ddl_txt from  DBA_REDEFINITION_ERRORS;

BEGIN
DBMS_REDEFINITION.FINISH_REDEF_TABLE('scott', 'emp', 'emp_1');
END;
/

BEGIN
DBMS_REDEFINITION.ABORT_REDEF_TABLE(uname => 'SCOTT',
orig_table => 'EMP',
int_table => 'EMP_1'
);
END;