Can't add partition : ORA-14074: partition bound must collate higher than that of the
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Can't add partition : ORA-14074: partition bound must collate higher than that of the

  1. #1
    Join Date
    Dec 2001
    Posts
    141

    Can't add partition : ORA-14074: partition bound must collate higher than that of the

    Hi all !

    I have a problem adding a new partition in a range partitioned table.
    The table was builded like this :

    create table test
    (
    c1 char(10) not null,
    c2 char(6) not null,
    ...
    c8 number(15),
    c9 number(15)
    )
    partition by range (c2)
    (partition 199901 values less than (199902),
    partition 199902 values less than (199903),
    ...
    partition 200212 values less than (200301));

    There are 3 bitmap indexes and 1 unique index, and there're all partitioned local.

    When I tried to execute :

    alter table test add partition P200301 values less than ('200302')

    I received the ORA-14074 error (partition bound must collate higher than that of the last partition).

    And don't understand why ?
    Can anyone help me please ?
    Thanks a lot in advance ...

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Look at the dba_tab_partitions.high_value to find out the value for the last partition.

    Use something like:
    Code:
    SELECT partition_name, high_value
    FROM   dba_tab_partitions
    WHERE  table_name = 'YOUR_TABLE'
    AND    table_owner = 'YOUR_OWNER'
    ORDER BY partition_position
    I am guessing you already have a partition that encompasses 200302.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Dec 2001
    Posts
    141
    Unfortunatly no, the high_value for the last partition (last partition_position) is '200301'.

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Hmm, do you have a maxvalue partition?
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  5. #5
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  6. #6
    Join Date
    Dec 2001
    Posts
    141
    No, there is no maxvalue partition ...

  7. #7
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Sounds like maybe you need to file a TAR with Oracle. Maybe your data dictionary got screwed up somehow...
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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