-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|