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')));