Table Partition Creation Error

Hi,

Can anyone point out where is the error in the below syntax ?

CREATE TABLE OP_TRAN (
PAT_CODE CHAR(12) NOT NULL,
VISIT_DT DATE,
PAT_ICODE NUMBER NOT NULL,
REF_DOC_CODE NUMBER,
CLINIC_STATUS CHAR(4) NOT NULL,
INIT_DIAG_UNIT NUMBER,
DISCHARGE_STATUS CHAR(1),
A_ICODE NUMBER,
OCCUPATION_CODE NUMBER)

PARTITION BY RANGE (VISIT_DT)(
PARTITION P1 VALUES LESS THAN ('01-JUN-1999') TABLESPACE TABPART,
PARTITION P2 VALUES LESS THAN ('01-DEC-1999') TABLESPACE TABPART_DAT,
PARTITION P3 VALUES LESS THAN ('01-JAN-2000') TABLESPACE USERS,
PARTITION P4 VALUES LESS THAN (MAXVALUE) TABLESPACE IDXPART );
PARTITION P1 VALUES LESS THAN ('01-JUN-1999') TABLESPACE TABPART,
Error: specifiying the date column
ORA-14120: incompletely specified partition bound for a DATE column


Thanks
Ravi

Hello Ravi,

I think you should try to replace for all your partition:

PARTITION P1 VALUES LESS THAN ('01-JUN-1999') TABLESPACE TABPART

WITH

PARTITION P1 VALUES LESS THAN (to_date('01-JUN-1999','DD-MON-YYYY')) TABLESPACE TABPART;

Format of your partionned field is a date and implicit conversion seems not allow in a partition clause.

Hope this help,
Have a nice day,
Stephane.