alter table PMMLOTINFO
add partition P2020 values less than ('20210101')
tablespace TBS_FPCSFCDATA
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 1M
next 1M
minextents 1
maxextents unlimited
pctincrease 0
)
partition by range (CREATEDATE)
(
partition P2013 values less than ('20140101')
tablespace TBS_FPCSFCDATA
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 2M
next 2M
minextents 1
maxextents unlimited
pctincrease 0
)
);