Oracle数据库11G新特性-间隔分区表

1.
   interval使用之后，就不用手工增加分区，来适应数据的增长。
2.
   根据年月 INTERVAL(NUMTOYMINTERVAL(1,'YEAR'))
                  INTERVAL(NUMTOYMINTERVAL(1,'MONTH'))
   根据天   INTERVAL(NUMTODSINTERVAL(1,'DAY'))

3.

 CREATE TABLE hr.int_par(
        id number primary key,
        join_date date )
      partition by range(join_date) interval (numtoyMinterval (1,'YEAR'))
      --store in (par01,par02,par03,par04,par05,par06,par07,par08,par09,par010,par011,par012)
      (
        partition inte_par1 VALUES LESS THAN (to_date('2000-9-9','YYYY-MM-DD'))
      )