SQL & PL/SQL

Hi all,

I am trying to create two partitions on one table. First
partition will hold the past three days data and 2nd partition
will hold rest of the data. Any thing wrong with this code?

CREATE TABLE TEST(TES NUMBER,
TTS DATE NOT NULL)
PARTITION BY RANGE (TTS) (
PARTITION TAB_PAST_3DAYS VALUES LESS THAN (TO_DATE(SYSDATE-
3,'DD-MON-YYYY')),
PARTITION TAB_REST VALUES LESS THAN (MAXVALUE) ));

I am getting error.

ERROR at line 4:
ORA-14019: partition bound element must be one of: string,
datetime or interval literal, number, or
MAXVALUE


Please help me.

Swetha.