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