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

);