oracle 修索引改空间_Oracle数据迁移及Oracle全局索引变更为分区索引

1.在新环境数据库用户下执行建需要迁移表的建表语句

CREATE TABLE "T_TSPS_CONDUCT_AUDITS" (

"C_ID" VARCHAR2(64 BYTE),

"N_PERSON_ID" NUMBER,

"C_CODE" VARCHAR2(64 BYTE),

"C_NAME" VARCHAR2(64 BYTE),

"C_DEPT" VARCHAR2(64 BYTE),

"N_LOG_TIME" NUMBER,

"C_LOG_TYPE" NUMBER,

"C_CONTENT" VARCHAR2(1024 BYTE),

"C_RESULT" VARCHAR2(2 BYTE),

"C_SN" VARCHAR2(128 BYTE),

"N_DEPT_ID" NUMBER,

"C_BLACK_FLAG" VARCHAR2(2 BYTE),

"C_CREATE_TIME" DATE,

"C_IDENTIFIER" VARCHAR2(36 BYTE)

) PARTITION BY RANGE (C_CREATE_TIME) interval (numtodsinterval (1,'DAY'))

(

PARTITION audit_p180613 VALUES LESS THAN (TO_DATE('2018-6-13', 'yyyy-mm-dd'))

);

​

COMMENT ON COLUMN "T_TSPS_CONDUCT