SQL & PL/SQL

Hi,

I am unable to add partition to a existing unpartitioned table, getting error as invalid data type and i am not finding any syntax errors.

ALTER TABLE MESSAGEX_XCHANGE

ADD PARTITION BY RANGE(LAST_MODIFY_TIMESTAMP)

(

PARTITION old_data VALUES LESS THAN(To_TIMESTAMP('27/02/2014','DD/MM/YYYY')),

PARTITION new_data VALUES LESS THAN(To_TIMESTAMP('28/02/2014','DD/MM/YYYY'))

);

Error report:

SQL Error: ORA-00902: invalid datatype

1. 00000 -  "invalid datatype"

*Cause:   

*Action:

Thanks,

Mahendran..