本文遵循BY-SA版权协议，转载请附上原文出处链接。

本文作者: 黑伴白

本文链接: http://heibanbai.com.cn/posts/399b63fe/

DB2分区表

DB2创建分区表

CREATE TABLE PART_MAIN(
P_ID VARCHAR(10),
P_DATE DATE
)
PARTITION BY RANGE(P_DATE) (
PARTITION OTHERS STARTING MINVALUE ENDING "20120331",
PARTITION P201204 STARTING "20120401" ENDING "20120430",
PARTITION P201205 STARTING "20120501" ENDING "20120531",
PARTITION P201206 STARTING "20120601" ENDING "20120630",
PARTITION P201212 STARTING "20121201" ENDING "20121231"
)
;

DB2分区表增加分区

alter table tableName add partition partName starting "20231201" ending "20240101" exclusive in tabspace index in indexspace;

---

蚂蚁再小也是肉🥩！