oracel 表分区,自动分区

https://blog.csdn.net/u013986802/article/details/71214312  --这个较全

https://www.cnblogs.com/zhangkaimin/p/11720239.html --自动分区

https://www.cnblogs.com/gemine/p/9011898.html

create table tableName
(
ID NUMBER(20) not null,
CREATE_TIME DATE
)
PARTITION BY RANGE (CREATE_TIME) INTERVAL (numtoyminterval(1, 'month'))
(partition part_t01 values less than(to_date('2018-11-01', 'yyyy-mm-dd')));

原文地址:https://www.cnblogs.com/Apeak/p/13938095.html