for example:
create table ttt
(
ITEM_NO VARCHAR2(13),
WEIGHT NUMBER(6,3),
BUSINESS_TYPEID CHAR(3),
D_OR_M CHAR(1),
IN_TIME CHAR(14),
IN_SERIAL_NO varchar2(20),
ORIGINAL_ORGID VARCHAR2(10),
ORIGINAL_ZONEID VARCHAR2(10),
ORIGINAL_ORGID_LEVEL NUMBER(1),
OUT_TIME CHAR(14),
OUT_SERIAL_NO varchar2(20),
DESTINATION_ORGID VARCHAR2(10),
DESTINATION_ZONEID VARCHAR2(10),
DESPATCH_ORGID VARCHAR2(10),
CREATE_SITE VARCHAR2(4),
IN_OR_OUT CHAR(1),
DEST_ORGID_LEVEL NUMBER(1),
DELI_TIME CHAR(14),
MONTH VARCHAR2(2),
CARRIER CHAR(1)
)
partition by range(MONTH) subpartition by list(CREATE_SITE)
(
partition mail_01 values less than ('02')
(
subpartition gdsz_01 values ('GD1') tablespace zone1_01,
subpartition gdgz_01 values ('GD2') tablespace zone2_01
),
partition mail_02 values less than ('03')
(
subpartition gdsz_02 values ('GDSZ') tablespace zone1_02,
subpartition gdgz_02 values ('GDGZ') tablespace zone2_02
),
partition mail_03 values less than ('04')
(
subpartition gdsz_03 values ('GDSZ') tablespace zone1_03,
subpartition gdgz_03 values ('GDGZ') tablespace zone2_03,
),
partition mail_04 values less than ('05')
(
subpartition gdsz_04 values ('GDSZ') tablespace zone1_04,
subpartition gdgz_04 values ('GDGZ') tablespace zone2_04
),
partition mail_05 values less than ('06')
(
subpartition gdsz_05 values ('GDSZ') tablespace zone1_05,
subpartition gdgz_05 values ('GDGZ') tablespace zone2_05
),
partition mail_06 values less than ('07')
(
subpartition gdsz_06 values ('GDSZ') tablespace zone1_06,
subpartition gdgz_06 values ('GDGZ') tablespace zone2_06
),
partition mail_07 values less than ('08')
(
subpartition gdsz_07 values ('GDSZ') tablespace zone1_07,
subpartition gdgz_07 values ('GDGZ') tablespace zone2_07
),
partition mail_08 values less than ('09')
(
subpartition gdsz_08 values ('GDSZ') tablespace zone1_08,
subpartition gdgz_08 values ('GDGZ') tablespace zone2_08
),
partition mail_09 values less than ('10')
(
subpartition gdsz_09 values ('GDSZ') tablespace zone1_09,
subpartition gdgz_09 values ('GDGZ') tablespace zone2_09
),
partition mail_10 values less than ('11')
(
subpartition gdsz_10 values ('GDSZ') tablespace zone1_10,
subpartition gdgz_10 values ('GDGZ') tablespace zone2_10
),
partition mail_11 values less than ('12')
(
subpartition gdsz_11 values ('GDSZ') tablespace zone1_11,
subpartition gdgz_11 values ('GDGZ') tablespace zone2_11
),
partition mail_12 values less than ('13')
(
subpartition gdsz_12 values ('GDSZ') tablespace zone1_12,
subpartition gdgz_12 values ('GDGZ') tablespace zone2_12
)
);
create table ttt
(
ITEM_NO VARCHAR2(13),
WEIGHT NUMBER(6,3),
BUSINESS_TYPEID CHAR(3),
D_OR_M CHAR(1),
IN_TIME CHAR(14),
IN_SERIAL_NO varchar2(20),
ORIGINAL_ORGID VARCHAR2(10),
ORIGINAL_ZONEID VARCHAR2(10),
ORIGINAL_ORGID_LEVEL NUMBER(1),
OUT_TIME CHAR(14),
OUT_SERIAL_NO varchar2(20),
DESTINATION_ORGID VARCHAR2(10),
DESTINATION_ZONEID VARCHAR2(10),
DESPATCH_ORGID VARCHAR2(10),
CREATE_SITE VARCHAR2(4),
IN_OR_OUT CHAR(1),
DEST_ORGID_LEVEL NUMBER(1),
DELI_TIME CHAR(14),
MONTH VARCHAR2(2),
CARRIER CHAR(1)
)
partition by range(MONTH) subpartition by list(CREATE_SITE)
(
partition mail_01 values less than ('02')
(
subpartition gdsz_01 values ('GD1') tablespace zone1_01,
subpartition gdgz_01 values ('GD2') tablespace zone2_01
),
partition mail_02 values less than ('03')
(
subpartition gdsz_02 values ('GDSZ') tablespace zone1_02,
subpartition gdgz_02 values ('GDGZ') tablespace zone2_02
),
partition mail_03 values less than ('04')
(
subpartition gdsz_03 values ('GDSZ') tablespace zone1_03,
subpartition gdgz_03 values ('GDGZ') tablespace zone2_03,
),
partition mail_04 values less than ('05')
(
subpartition gdsz_04 values ('GDSZ') tablespace zone1_04,
subpartition gdgz_04 values ('GDGZ') tablespace zone2_04
),
partition mail_05 values less than ('06')
(
subpartition gdsz_05 values ('GDSZ') tablespace zone1_05,
subpartition gdgz_05 values ('GDGZ') tablespace zone2_05
),
partition mail_06 values less than ('07')
(
subpartition gdsz_06 values ('GDSZ') tablespace zone1_06,
subpartition gdgz_06 values ('GDGZ') tablespace zone2_06
),
partition mail_07 values less than ('08')
(
subpartition gdsz_07 values ('GDSZ') tablespace zone1_07,
subpartition gdgz_07 values ('GDGZ') tablespace zone2_07
),
partition mail_08 values less than ('09')
(
subpartition gdsz_08 values ('GDSZ') tablespace zone1_08,
subpartition gdgz_08 values ('GDGZ') tablespace zone2_08
),
partition mail_09 values less than ('10')
(
subpartition gdsz_09 values ('GDSZ') tablespace zone1_09,
subpartition gdgz_09 values ('GDGZ') tablespace zone2_09
),
partition mail_10 values less than ('11')
(
subpartition gdsz_10 values ('GDSZ') tablespace zone1_10,
subpartition gdgz_10 values ('GDGZ') tablespace zone2_10
),
partition mail_11 values less than ('12')
(
subpartition gdsz_11 values ('GDSZ') tablespace zone1_11,
subpartition gdgz_11 values ('GDGZ') tablespace zone2_11
),
partition mail_12 values less than ('13')
(
subpartition gdsz_12 values ('GDSZ') tablespace zone1_12,
subpartition gdgz_12 values ('GDGZ') tablespace zone2_12
)
);
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货