oracle 11g分区表创建

CREATE TABLE TEST
(
   add_DATE DATE
)
PARTITION BY RANGE(add_DATE)
INTERVAL(NUMTOYMINTERVAL(1，'MONTH'))
(
  PARTITION P01 VALUES LESS THAN(TO_DATE('20160131','YYYYMMDD'))
);

create table TEST
(
   add_DATE varchar2(8) not null
)
partition by range (add_DATE )
(
   PARTITION P01 VALUES LESS THAN('20160131') tablespace USERS ,
   partition P02 VALUES LESS THAN('20160231') tablespace USERS ,
   partition P03 VALUES LESS THAN('20160331') tablespace USERS ,
   partition P04 VALUES LESS THAN('20160431') tablespace USERS ,
   partition P05 VALUES LESS THAN('20160531') tablespace USERS ,
   partition P06 VALUES LESS THAN('20160631') tablespace USERS ,
   partition P07 VALUES LESS THAN('20160731') tablespace USERS ,
   partition P08 VALUES LESS THAN('20160831') tablespace USERS ,
   partition P09 VALUES LESS THAN('20160931') tablespace USERS ,
   partition P10 VALUES LESS THAN('20161031') tablespace USERS ,
   partition P11 VALUES LESS THAN('20161131') tablespace USERS ,
   partition P12 VALUES LESS THAN('20161231') tablespace USERS
);