Create partitioned PK (index) erro 14021
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Create partitioned PK (index) erro 14021

  1. #1
    Join Date
    Aug 2000
    Location
    Sao Paulo
    Posts
    114

    Question

    What does with this creation happen???


    I already tried to place the maxvalue in the place of the less then but it doesn't work.
    how can I correct and to create this pk???

    Look the copy of sqlplus


    SQL> ALTER TABLE MAXSYS_VIEW_new ADD CONSTRAINT PK_MAXSYS_VIEW_new
    2 PRIMARY KEY
    3 (IDMARKET,IDNETWORK,NDATE,NTIME,IDINDIVIDUAL,IDTV)
    4 USING INDEX
    5 global PARTITION BY RANGE (idmarket)
    6 (
    7 PARTITION nacion_i VALUES LESS THAN (2) TABLESPACE Maxsys_p_nacion_I,
    8 PARTITION saopau_i VALUES LESS THAN (513) TABLESPACE Maxsys_p_saopa_I,
    9 PARTITION dfsacu_i VALUES LESS THAN (525) TABLESPACE Maxsys_p_dfsacu_I,
    10 PARTITION bhrefo_i VALUES LESS THAN (606) TABLESPACE Maxsys_p_bhfore_I,
    11 PARTITION riojan_i VALUES LESS THAN (615) TABLESPACE Maxsys_p_rioja_I,
    12 PARTITION porflo_i VALUES LESS THAN (651) TABLESPACE Maxsys_p_poaflo_I
    13 )
    14 /
    )
    *
    ERRO na linha 13:
    ORA-14021: MAXVALUE must be specified for all columns

  2. #2
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    ...
    PARTITION bhrefo_i VALUES LESS THAN (606) TABLESPACE Maxsys_p_bhfore_I,
    PARTITION riojan_i VALUES LESS THAN (615) TABLESPACE Maxsys_p_rioja_I,
    PARTITION porflo_i VALUES LESS THAN (651) TABLESPACE Maxsys_p_poaflo_I
    PARTITION maximum_i VALUES LESS THAN (MAXVALUE) TABLESPACE Maxvalue_...I
    )
    /
    )

  3. #3
    Join Date
    Aug 2000
    Location
    Sao Paulo
    Posts
    114

    Wink

    OK let try this way , and tank you for the attention.

  4. #4
    Join Date
    Aug 2000
    Location
    Sao Paulo
    Posts
    114

    Talking

    Ok Worked correctly, thankful.

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