创建按月自动分区表

create table month_interval_partition_table
(id number,time_col date) partition by range(time_col)
interval (numtoyminterval(1,'month'))
(
partition p_month_1 values less than (to_date('2014-01-01','yyyy-mm-dd'))
);