PARTITION p1 VALUES LESS THAN (to_date('2005-01-01','YYYY-MM-DD')) ,PARTITION p2 VALUES LESS THAN (to_date('2010-01-01','YYYY-MM-DD')) ...