oracle修改分区表数据,oracle在线将原表修改为分区表

EXEC DBMS_REDEFINITION.CAN_REDEF_TABLE(USER, 't_audit_businessobjectinfo', DBMS_REDEFINITION.CONS_USE_PK);

create table T_AUDIT_BUSINESSOBJECTINFO_NEW

(

ID             NUMBER not null,

AUDIT_PER_NAME VARCHAR2(50) not null,

AUDIT_PER_ID   NUMBER not null,

AUDIT_ROLE_ID  NUMBER not null,

AUDIT_DATE     DATE not null,

PASSED         CHAR(1) default '1' not null,

AUDIT_COMMENT  VARCHAR2(512) default '同意' not null,

ADJUNCT        VARCHAR2(200),

ADJUNCT_TITLE  VARCHAR2(100),

SOURCE_ID      VARCHAR2(200),

BUSINESS_TYPE  NUMBER,

FLOWID         VARCHAR2(100),

DEGREE         VARCHAR2(2),

AUDITORDER     NUMBER

) PARTITION BY RANGE (AUDIT_DATE)

(PARTITION P1 VALUES LESS THAN (TO_DATE('2007-1-1', 'YYYY-MM-DD')),

PARTITION P2 VALUES LESS THAN (TO_DATE('2008-1-1', 'YYYY-MM-DD')),

PARTITION P3 VALUES LESS THAN (MAXVALUE));

EXEC DBMS_REDEFINITION.START_REDEF_TABLE(USER, 'T_AUDIT_BUSINESSOBJECTINFO', 'T_AUDIT_BUSINESSOBJECTINFO_NEW', 'ID ID,  AUDIT_PER_NAME  AUDIT_PER_NAME,  AUDIT_PER_ID    AUDIT_PER_ID,  AUDIT_ROLE_ID AUDIT_ROLE_ID,  AUDIT_DATE      AUDIT_DATE,  PASSED      PASSED   ,  AUDIT_COMMENT   AUDIT_COMMENT,  ADJUNCT        ADJUNCT ,  ADJUNCT_TITLE  ADJUNCT_TITLE,  SOURCE_ID     SOURCE_ID ,  BUSINESS_TYPE  BUSINESS_TYPE,  FLOWID       FLOWID ,  DEGREE      DEGREE   ,  AUDITORDER AUDITORDER', DBMS_REDEFINITION.CONS_USE_PK);

drop materialized view log on T_AUDIT_BUSINESSOBJECTINFO;

EXEC DBMS_REDEFINITION.FINISH_REDEF_TABLE(USER, 'T_AUDIT_BUSINESSOBJECTINFO', 'T_AUDIT_BUSINESSOBJECTINFO_NEW')