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