Table Partition Creation Error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Table Partition Creation Error

  1. #1
    Join Date
    Aug 2000
    Posts
    33
    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

  2. #2
    Join Date
    Dec 2000
    Posts
    10
    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
  •  



Click Here to Expand Forum to Full Width