Partition by Range on a Char datatype

[marist89]

You're telling oracle you have a table with a char datatype and you want to range partition on dates. USe something like:

CREATE TABLE MYTABLE_PARTN ("COL1" CHAR(31), "COL2" CHAR(31), "COL3" CHAR(31))
partition by range (COL3)
(
partition p1 values less than ('2004-07-28') tablespace my_data,
partition p2 values less than ('2004-07-29') tablespace my_data,
);

The date format will drive what you use as values for the partitioning clause. This is why slimdave said this design needs some work...