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