CREATE TABLE A
(
a NUMBER,
CreationDate DATE
)
PARTITION BY RANGE (CreationDate)
INTERVAL ( NUMTODSINTERVAL (1, 'DAY') )
(PARTITION P_FIRST
VALUES LESS THAN (TIMESTAMP ' 2001-01-01 00:00:00'))