ORACLE 11G间隔分区特性

CREATE TABLE AAA
(
ID NUMBER(20),
NAME VARCHAR2(128),
RTIME DATE
)
PARTITION BY RANGE (RTIME)
--INTERVAL(NUMTOYMINTERVAL(1,'MONTH'))
INTERVAL(NUMTODSINTERVAL(1, 'DAY'))
(
PARTITION PAAA VALUES LESS THAN (to_date('2013-05-28','yyyy-mm-dd'))

);