发布于

请教偶数支持类似oracle的那种复合分区键创建分区表吗?

Oracle 中建表语句如下,偶数支持这种分区的创建吗?
CREATE TABLE ."TEMP_LFC_ZCDWK_ACCT" (
"MONTH_ID" VARCHAR2(6),
"DAY_ID" VARCHAR2(6),
"PROV_ID" VARCHAR2(6),
"FLAG" VARCHAR2(2)
)
PARTITION BY RANGE ("MONTH_ID","PROV_ID")
SUBPARTITION BY LIST ("DAY_ID")
(
PARTITION "PART201801_049" VALUES LESS THAN('201801', '050')
(
SUBPARTITION "PART201801_049_SUBPART_01" VALUES ('01') ,
SUBPARTITION "PART201801_049_SUBPART_02" VALUES ('02') ,
SUBPARTITION "PART201801_049_SUBPART_03" VALUES ('03') ,
SUBPARTITION "PART201801_049_SUBPART_04" VALUES ('04') ,
SUBPARTITION "PART201801_049_SUBPART_05" VALUES ('05') ,
SUBPARTITION "PART201801_049_SUBPART_06" VALUES ('06') ,
SUBPARTITION "PART201801_049_SUBPART_07" VALUES ('07') ,
SUBPARTITION "PART201801_049_SUBPART_08" VALUES ('08') ,
SUBPARTITION "PART201801_049_SUBPART_09" VALUES ('09') ,
SUBPARTITION "PART201801_049_SUBPART_10" VALUES ('10') ,
SUBPARTITION "PART201801_049_SUBPART_11" VALUES ('11') ,
SUBPARTITION "PART201801_049_SUBPART_12" VALUES ('12') ,
SUBPARTITION "PART201801_049_SUBPART_13" VALUES ('13') ,
SUBPARTITION "PART201801_049_SUBPART_14" VALUES ('14') ,
SUBPARTITION "PART201801_049_SUBPART_15" VALUES ('15') ,
SUBPARTITION "PART201801_049_SUBPART_16" VALUES ('16') ,
SUBPARTITION "PART201801_049_SUBPART_17" VALUES ('17') ,
SUBPARTITION "PART201801_049_SUBPART_18" VALUES ('18') ,
SUBPARTITION "PART201801_049_SUBPART_19" VALUES ('19') ,
SUBPARTITION "PART201801_049_SUBPART_20" VALUES ('20') ,
SUBPARTITION "PART201801_049_SUBPART_21" VALUES ('21') ,
SUBPARTITION "PART201801_049_SUBPART_22" VALUES ('22') ,
SUBPARTITION "PART201801_049_SUBPART_23" VALUES ('23') ,
SUBPARTITION "PART201801_049_SUBPART_24" VALUES ('24') ,
SUBPARTITION "PART201801_049_SUBPART_25" VALUES ('25') ,
SUBPARTITION "PART201801_049_SUBPART_26" VALUES ('26') ,
SUBPARTITION "PART201801_049_SUBPART_27" VALUES ('27') ,
SUBPARTITION "PART201801_049_SUBPART_28" VALUES ('28') ,
SUBPARTITION "PART201801_049_SUBPART_29" VALUES ('29') ,
SUBPARTITION "PART201801_049_SUBPART_30" VALUES ('30') ,
SUBPARTITION "PART201801_049_SUBPART_31" VALUES ('31')
),
PARTITION "PART201801_050" VALUES LESS THAN('201801', '051')
(
SUBPARTITION "PART201801_050_SUBPART_01" VALUES ('01') ,
SUBPARTITION "PART201801_050_SUBPART_02" VALUES ('02') ,
SUBPARTITION "PART201801_050_SUBPART_03" VALUES ('03') ,
SUBPARTITION "PART201801_050_SUBPART_04" VALUES ('04') ,
SUBPARTITION "PART201801_050_SUBPART_05" VALUES ('05') ,
SUBPARTITION "PART201801_050_SUBPART_06" VALUES ('06') ,
SUBPARTITION "PART201801_050_SUBPART_07" VALUES ('07') ,
SUBPARTITION "PART201801_050_SUBPART_08" VALUES ('08') ,
SUBPARTITION "PART201801_050_SUBPART_09" VALUES ('09') ,
SUBPARTITION "PART201801_050_SUBPART_10" VALUES ('10') ,
SUBPARTITION "PART201801_050_SUBPART_11" VALUES ('11') ,
SUBPARTITION "PART201801_050_SUBPART_12" VALUES ('12') ,
SUBPARTITION "PART201801_050_SUBPART_13" VALUES ('13') ,
SUBPARTITION "PART201801_050_SUBPART_14" VALUES ('14') ,
SUBPARTITION "PART201801_050_SUBPART_15" VALUES ('15') ,
SUBPARTITION "PART201801_050_SUBPART_16" VALUES ('16') ,
SUBPARTITION "PART201801_050_SUBPART_17" VALUES ('17') ,
SUBPARTITION "PART201801_050_SUBPART_18" VALUES ('18') ,
SUBPARTITION "PART201801_050_SUBPART_19" VALUES ('19') ,
SUBPARTITION "PART201801_050_SUBPART_20" VALUES ('20') ,
SUBPARTITION "PART201801_050_SUBPART_21" VALUES ('21') ,
SUBPARTITION "PART201801_050_SUBPART_22" VALUES ('22') ,
SUBPARTITION "PART201801_050_SUBPART_23" VALUES ('23') ,
SUBPARTITION "PART201801_050_SUBPART_24" VALUES ('24') ,
SUBPARTITION "PART201801_050_SUBPART_25" VALUES ('25') ,
SUBPARTITION "PART201801_050_SUBPART_26" VALUES ('26') ,
SUBPARTITION "PART201801_050_SUBPART_27" VALUES ('27') ,
SUBPARTITION "PART201801_050_SUBPART_28" VALUES ('28') ,
SUBPARTITION "PART201801_050_SUBPART_29" VALUES ('29') ,
SUBPARTITION "PART201801_050_SUBPART_30" VALUES ('30') ,
SUBPARTITION "PART201801_050_SUBPART_31" VALUES ('31')
)
);

评论
    test