Hi

I am attempting to a table partition based on the month. My intension is to keep all the records based on the month irrespective of the year. For example, all the January records go into Jan_Partition, Feb records into Feb_Partition and so on..

Currently the table I am attempting, containing one varchar2 field, which contains the data like 'MMDDYYYYXXXXXXX'.
When I tryto partition this table I am getting ora-14019 error.

I tried like this:

CREATE TABLE CALLLOG3 (
CALLLOG_ID NUMBER (18) NOT NULL,
SESSION_ID VARCHAR2 (18) DEFAULT '0',
CONSTRAINT PK_CALLLOG3
PRIMARY KEY ( CALLLOG_ID )
USING INDEX
TABLESPACE INDEX_SSP1_TRANSACTION PCTFREE 10
STORAGE ( INITIAL 65536 NEXT 81920 PCTINCREASE 0 ))
TABLESPACE USERS_SSP1_TRANSACTION NOLOGGING
PARTITION BY RANGE (SESSION_ID)
(PARTITION calllog3_jan VALUES LESS THAN(substr('02212001',1,2))
TABLESPACE USERS_SSP1_TRANSACTION,
PARTITION calllog3_dec VALUES LESS THAN (MAXVALUE)
TABLESPACE USERS_SSP1_TRANSACTION)

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

Can anyone shed some light on this?


Thanks In Advance.