### DPC建一级分区表
CREATE TABLE “SYSDBA”.“TEST”
(
“ID” BIGINT NOT NULL,
“ARCHIVE_ID” BIGINT NOT NULL,
“TENANT_ID” BIGINT NOT NULL,
“LABEL_CODE” VARCHAR(256) DEFAULT ‘’ NOT NULL,
“MANAGE_ORG_CODE” VARCHAR(256),
NOT CLUSTER PRIMARY KEY(“ID”, “ARCHIVE_ID”))
PARTITION BY HASH(“ARCHIVE_ID”) partitions default;
使用PARTITION BY HASH(“ARCHIVE_ID”) partitions default的方式，
可以不需要建分组，可以自动根据当前用户的表空间数自动分区。

二级分区

CREATE TABLE “SYSDBA”.“TEST”
(
“ID” BIGINT NOT NULL,
“ARCHIVE_ID” BIGINT NOT NULL,
“TENANT_ID” BIGINT NOT NULL,
“LABEL_CODE” VARCHAR(256) DEFAULT ‘’ NOT NULL,
“MANAGE_ORG_CODE” VARCHAR(256),
NOT CLUSTER PRIMARY KEY(“ID”,“ARCHIVE_ID”))
PARTITION BY RANGE(“ARCHIVE_ID”)
SUBPARTITION BY HASH(“ID”) SUBPARTITIONS DEFAULT
(
PARTITION P1 VALUES LESS THAN(1000),
PARTITION P2 VALUES LESS THAN(2000),
PARTITION P3 VALUES LESS THAN(MAXVALUE)
);

集中式数据库
需要指定分区
CREATE TABLE “SYSDBA”.“TEST”
(
“ID” BIGINT NOT NULL,
“ARCHIVE_ID” BIGINT NOT NULL,
“TENANT_ID” BIGINT NOT NULL,
“LABEL_CODE” VARCHAR(256) DEFAULT ‘’ NOT NULL,
“MANAGE_ORG_CODE” VARCHAR(256),
NOT CLUSTER PRIMARY KEY(“ID”,“ARCHIVE_ID”))
PARTITION BY HASH(“ARCHIVE_ID”)
(
PARTITION “DMHASHPART0”,
PARTITION “DMHASHPART1”,
PARTITION “DMHASHPART2”
);
二级分区
CREATE TABLE “SYSDBA”.“TEST2”
(
“CARD_NO” VARCHAR2(216),
“SERIALNUM_ID” VARCHAR2(288) NOT NULL,
“DATAGENERATE_DATE” DATE,
“PATIENT_ID” VARCHAR2(288),
“DOMAIN_CODE” VARCHAR2(108),
“ORGANIZATION_CODE” VARCHAR2(198),
“ORGANIZATION_NAME” VARCHAR2(1800),
“CREATE_DATE” VARCHAR2(126),
“LAST_UPDATE_DTIME” VARCHAR2(126))
PARTITION BY RANGE(“LAST_UPDATE_DTIME”)
SUBPARTITION BY HASH(“PATIENT_ID”) SUBPARTITION TEMPLATE
SUBPARTITIONS 3
(
PARTITION “S_LESS” VALUES LESS THAN(‘2020-01-01 00:00:00’),
PARTITION “S_2020q1” VALUES LESS THAN(‘2020-04-01 00:00:00’),
PARTITION “S_2020q2” VALUES LESS THAN(‘2020-07-01 00:00:00’),
PARTITION “S_2020q3” VALUES LESS THAN(‘2020-10-01 00:00:00’),
PARTITION “S_MORE” VALUES LESS THAN(MAXVALUE)
);