How to partition an oracle table by a date column?
What you want to do is completely possible. This should do it:
CREATE TABLE transaction ( id INT NOT NULL, accountnumber VARCHAR2(30) NOT NULL, stmtvaluedate DATE NOT NULL)PARTITION BY RANGE (stmtvaluedate)INTERVAL (NUMTOYMINTERVAL (1,'MONTH')) ( partition transaction_old values less than (to_date('01-JAN-2000','DD-MON-YYYY') ));