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