alter query to partition a non-partitioned table in oracle 9i
now i want to add range partition in it on column sales_date as:
PARTITION sales_jan2000 VALUES LESS THAN(TO_DATE('02/01/2011','DD/MM/YYYY')),
PARTITION sales_feb2000 VALUES LESS THAN(TO_DATE('03/01/2011','DD/MM/YYYY')),
PARTITION sales_mar2000 VALUES LESS THAN(TO_DATE('04/01/2011','DD/MM/YYYY')),
PARTITION sales_apr2000 VALUES LESS THAN(TO_DATE('05/01/2011','DD/MM/YYYY'