--历史表的分区创建
partition by range (part_min)
(
partition part_1 values less than ('15')
tablespace tbs_lbi_dm
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 8m
next 1m
minextents 1
maxextents unlimited
),
partition part_2 values less than ('30')
tablespace tbs_lbi_dm
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 8m
next 1m
minextents 1
maxextents unlimited
),
partition part_3 values less than ('45')
tablespace tbs_lbi_dm
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 8m
next 1m
minextents 1
maxextents unlimited
),
partition part_4 values less than ('60')
tablespace tbs_lbi_dm
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 8m
next 1m
minextents 1
maxextents unlimited
)
);