oracle自动分区设置

create table t_range (id number not null PRIMARY KEY, test_date date)
partition by range (test_date) interval (numtoyMinterval (1,'MONTH'))
(
partition p_2016_01_01 values less than (to_date('2016-01-01', 'yyyy-mm-dd'))
);

select partition_name from user_tab_partitions where table_name='T_RANGE';

alter table t_range rename partition P_2014_01_01 to p_2016_01_01;

insert  into t_range select rownum,
to_date(to_char(sysdate - 140, 'J') +
trunc(dbms_random.value(0, 80)),
'J')
from dual
connect by rownum <= 100000;

 select partition_name from user_tab_partitions where table_name='T_RANGE';
 
 
 SELECT STATEMENT, GOAL = ALL_ROWS