Oracle_Pl、Sql_create_partition_table

CREATE TABLE "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N_N"
( "TRACEID" NUMBER(32,0) NOT NULL ENABLE,
"SOURCETYPE" NVARCHAR2(32) NOT NULL ENABLE,
"SOURCEID" NVARCHAR2(32) NOT NULL ENABLE,
"OPERATORID" NUMBER(16,0) NOT NULL ENABLE,
"OPERATETIME" DATE NOT NULL ENABLE,
"OPERATIONTYPE" CHAR(1) NOT NULL ENABLE,
"REMOTEIP" NVARCHAR2(256) NOT NULL ENABLE,
"ELAPSEDTIME" TIMESTAMP (6) NOT NULL ENABLE,
"SERVERIP" NVARCHAR2(256) NOT NULL ENABLE,
"CHANGECONTENT" CLOB,
CONSTRAINT "PSYSTEM_DATACHANGETRACE_N" PRIMARY KEY ("TRACEID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEMT" ENABLE)
SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
LOB ("CHANGECONTENT") STORE AS BASICFILE (
TABLESPACE "SYSTEMT" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
NOCACHE LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
partition by range (OPERATETIME)
(
PARTITION SYSTEM_DATACHANGETRACE_N_N201806 VALUES LESS THAN (TO_DATE('2018-06-01 00:00:00','yyyy/mm/dd hh24:mi:ss')) TABLESPACE SYSTEMT,
PARTITION SYSTEM_DATACHANGETRACE_N_N201807 VALUES LESS THAN (TO_DATE('2018-07-01 00:00:00','yyyy/mm/dd hh24:mi:ss')) TABLESPACE SYSTEMT,
PARTITION SYSTEM_DATACHANGETRACE_N_N201808 VALUES LESS THAN (TO_DATE('2018-08-01 00:00:00','yyyy/mm/dd hh24:mi:ss')) TABLESPACE SYSTEMT,
PARTITION SYSTEM_DATACHANGETRACE_N_N201809 VALUES LESS THAN (TO_DATE('2018-09-01 00:00:00','yyyy/mm/dd hh24:mi:ss')) TABLESPACE SYSTEMT,
PARTITION SYSTEM_DATACHANGETRACE_N_N201810 VALUES LESS THAN (TO_DATE('2018-10-01 00:00:00','yyyy/mm/dd hh24:mi:ss')) TABLESPACE SYSTEMT,
PARTITION SYSTEM_DATACHANGETRACE_N_N201811 VALUES LESS THAN (TO_DATE('2018-11-01 00:00:00','yyyy/mm/dd hh24:mi:ss')) TABLESPACE SYSTEMT,
PARTITION SYSTEM_DATACHANGETRACE_N_N201812 VALUES LESS THAN (TO_DATE('2018-12-01 00:00:00','yyyy/mm/dd hh24:mi:ss')) TABLESPACE SYSTEMT，
PARTITION SYSTEM_DATACHANGETRACE_N_N201901 VALUES LESS THAN (TO_DATE('2019-01-01 00:00:00','yyyy/mm/dd hh24:mi:ss')) TABLESPACE SYSTEMT，
PARTITION SYSTEM_DATACHANGETRACE_N_N201802 VALUES LESS THAN (TO_DATE('2019-02-01 00:00:00','yyyy/mm/dd hh24:mi:ss')) TABLESPACE SYSTEMT，
PARTITION SYSTEM_DATACHANGETRACE_N_N201803 VALUES LESS THAN (TO_DATE('2019-03-01 00:00:00','yyyy/mm/dd hh24:mi:ss')) TABLESPACE SYSTEMT，
PARTITION SYSTEM_DATACHANGETRACE_N_N201804 VALUES LESS THAN (TO_DATE('2019-04-01 00:00:00','yyyy/mm/dd hh24:mi:ss')) TABLESPACE SYSTEMT，
PARTITION SYSTEM_DATACHANGETRACE_N_N201805 VALUES LESS THAN (TO_DATE('2019-05-01 00:00:00','yyyy/mm/dd hh24:mi:ss')) TABLESPACE SYSTEMT，
PARTITION SYSTEM_DATACHANGETRACE_N_N201806 VALUES LESS THAN (TO_DATE('2019-06-01 00:00:00','yyyy/mm/dd hh24:mi:ss')) TABLESPACE SYSTEMT
);

CREATE INDEX "SYSTEMUSER"."ISYSTEM_DATACHANGETRACE_N" ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" ("SOURCEID", "SOURCETYPE")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEMT" ;

COMMENT ON COLUMN "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N"."TRACEID" IS '跟踪ID@ ';
COMMENT ON COLUMN "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N"."SOURCETYPE" IS '数据源类型@ ';
COMMENT ON COLUMN "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N"."SOURCEID" IS '数据记录主键@ ';
COMMENT ON COLUMN "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N"."OPERATORID" IS '操作人@ ';
COMMENT ON COLUMN "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N"."OPERATETIME" IS '操作时间@ ';
COMMENT ON COLUMN "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N"."OPERATIONTYPE" IS '操作@操作，U - 更新 D - 删除 ';
COMMENT ON COLUMN "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N"."REMOTEIP" IS '操作IP@ ';
COMMENT ON COLUMN "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N"."ELAPSEDTIME" IS '持续时间@ ';
COMMENT ON COLUMN "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N"."SERVERIP" IS '服务器IP@ ';
COMMENT ON COLUMN "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N"."CHANGECONTENT" IS '变更内容@变更内容，使用XML格式包含修改明细的内容，格式如下
<源>
<变更列名1 FROM=“源值" TO="目标值" />
<变更列名2 FROM=“源值" TO="目标值" />
</源> ';

GRANT SELECT ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "RESOURCE";
GRANT UPDATE ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "RESOURCE";
GRANT QUERY REWRITE ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "RESOURCE";
GRANT ON COMMIT REFRESH ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "RESOURCE";
GRANT INSERT ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "RESOURCE";
GRANT FLASHBACK ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "RESOURCE";
GRANT DELETE ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "RESOURCE";
GRANT DEBUG ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "RESOURCE";
GRANT ALTER ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "RESOURCE";
GRANT QUERY REWRITE ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "FILEUSER";
GRANT QUERY REWRITE ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "REPORTUSER";
GRANT QUERY REWRITE ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "DEVICEUSER";
GRANT QUERY REWRITE ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "PLANUSER";
GRANT QUERY REWRITE ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "OTHERUSER";
GRANT QUERY REWRITE ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "WAYBILLUSER";
GRANT QUERY REWRITE ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "FREIGHTUSER";
GRANT QUERY REWRITE ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "PERMITUSER";
GRANT QUERY REWRITE ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "BASISUSER";
GRANT QUERY REWRITE ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "APPUSER";
GRANT ON COMMIT REFRESH ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "FILEUSER";
GRANT ON COMMIT REFRESH ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "REPORTUSER";
GRANT ON COMMIT REFRESH ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "DEVICEUSER";
GRANT ON COMMIT REFRESH ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "PLANUSER";
GRANT ON COMMIT REFRESH ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "OTHERUSER";
GRANT ON COMMIT REFRESH ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "WAYBILLUSER";
GRANT ON COMMIT REFRESH ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "FREIGHTUSER";
GRANT ON COMMIT REFRESH ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "PERMITUSER";
GRANT ON COMMIT REFRESH ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "BASISUSER";
GRANT ON COMMIT REFRESH ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "APPUSER";
GRANT REFERENCES ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "FILEUSER";
GRANT REFERENCES ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "REPORTUSER";
GRANT REFERENCES ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "DEVICEUSER";
GRANT REFERENCES ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "PLANUSER";
GRANT REFERENCES ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "OTHERUSER";
GRANT REFERENCES ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "WAYBILLUSER";
GRANT REFERENCES ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "FREIGHTUSER";
GRANT REFERENCES ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "PERMITUSER";
GRANT REFERENCES ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "BASISUSER";
GRANT REFERENCES ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "APPUSER";
GRANT UPDATE ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "FILEUSER";
GRANT UPDATE ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "REPORTUSER";
GRANT UPDATE ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "DEVICEUSER";
GRANT UPDATE ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "PLANUSER";
GRANT UPDATE ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "OTHERUSER";
GRANT UPDATE ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "WAYBILLUSER";
GRANT UPDATE ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "FREIGHTUSER";
GRANT UPDATE ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "PERMITUSER";
GRANT UPDATE ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "BASISUSER";
GRANT UPDATE ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "APPUSER";
GRANT SELECT ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "FILEUSER";
GRANT SELECT ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "REPORTUSER";
GRANT SELECT ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "DEVICEUSER";
GRANT SELECT ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "PLANUSER";
GRANT SELECT ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "OTHERUSER";
GRANT SELECT ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "WAYBILLUSER";
GRANT SELECT ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "FREIGHTUSER";
GRANT SELECT ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "PERMITUSER";
GRANT SELECT ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "BASISUSER";
GRANT SELECT ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "APPUSER";
GRANT INSERT ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "FILEUSER";
GRANT INSERT ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "REPORTUSER";
GRANT INSERT ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "DEVICEUSER";
GRANT INSERT ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "PLANUSER";
GRANT INSERT ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "OTHERUSER";
GRANT INSERT ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "WAYBILLUSER";
GRANT INSERT ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "FREIGHTUSER";
GRANT INSERT ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "PERMITUSER";
GRANT INSERT ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "BASISUSER";
GRANT INSERT ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "APPUSER";
GRANT INDEX ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "FILEUSER";
GRANT INDEX ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "REPORTUSER";
GRANT INDEX ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "DEVICEUSER";
GRANT INDEX ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "PLANUSER";
GRANT INDEX ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "OTHERUSER";
GRANT INDEX ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "WAYBILLUSER";
GRANT INDEX ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "FREIGHTUSER";
GRANT INDEX ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "PERMITUSER";
GRANT INDEX ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "BASISUSER";
GRANT INDEX ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "APPUSER";
GRANT DELETE ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "FILEUSER";
GRANT DELETE ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "REPORTUSER";
GRANT DELETE ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "DEVICEUSER";
GRANT DELETE ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "PLANUSER";
GRANT DELETE ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "OTHERUSER";
GRANT DELETE ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "WAYBILLUSER";
GRANT DELETE ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "FREIGHTUSER";
GRANT DELETE ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "PERMITUSER";
GRANT DELETE ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "BASISUSER";
GRANT DELETE ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "APPUSER";
GRANT ALTER ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "FILEUSER";
GRANT ALTER ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "REPORTUSER";
GRANT ALTER ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "DEVICEUSER";
GRANT ALTER ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "PLANUSER";
GRANT ALTER ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "OTHERUSER";
GRANT ALTER ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "WAYBILLUSER";
GRANT ALTER ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "FREIGHTUSER";
GRANT ALTER ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "PERMITUSER";
GRANT ALTER ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "BASISUSER";
GRANT ALTER ON "SYSTEMUSER"."SYSTEM_DATACHANGETRACE_N" TO "APPUSER";