ORA-14074: partition bound must collate higher than that of the last partition

in Oracle Development and Fusion Middleware; Hi. i want to add partition to my table, raised this error: ORA-14074: partition bound must collate higher than that ...
+ Post Reply + Post New Topic
Results 1 to 3 of 3
  1. #1
    goodarzi121 is offline Junior Member
    Points: 40, Level: 1
    Join Date
    05 May 2009
    Posts
    1
    Points
    40

    Unhappy ORA-14074: partition bound must collate higher than that of the last partition

    Hi.

    i want to add partition to my table, raised this error:

    ORA-14074: partition bound must collate higher than that of the last partition

    i think that raised error, because i have a partition with "MaxValue".

    please help me to solve that!


  2. #2
    sameer's Avatar
    sameer is offline Forum Advisor
    Points: 2,240, Level: 28
    Join Date
    21 Aug 2008
    Posts
    105
    Points
    2,240

    Re: ORA-14074: partition bound must collate higher than that of the last partition

    This error happens when you try to add or create a new partition to a partitioned table between two partitions, or the new partition is located at the beginning or in the middle of a table, or if the partition bound on the highest partition is MAXVALUE (i.e. original partition was created with the highest partition defined as MAXVALUE on the partition key).

    You can verify that this is the case by the following query

    Code sql:
    SELECT high_value
      FROM dba_tab_partitions
     WHERE TABLE_NAME = 'table_name';

    What you need to do is SPLIT the Partition, like this for example

    Code sql:
    ALTER TABLE TABLE_NAME 
        SPLIT PARTITION pmaxvalue 
        AT (40) 
        INTO (  PARTITION newpartition, 
                PARTITION pmaxvalue
             );
    Learning is a path with no destination...
    goodarzi121 says Thanks.

  3. #3
    rajavu's Avatar
    rajavu is offline Forum Guru
    Points: 10,830, Level: 68
    Join Date
    13 Oct 2008
    Location
    @ Bangalore , India
    Posts
    815
    Points
    10,830

    Re: ORA-14074: partition bound must collate higher than that of the last partition

    Check the following link for more information on split partition .
    Split Partition

    Raj.
    goodarzi121 says Thanks.

Other Solutions
  1. Replies: 1
    Last Post: 01-11-2010, 11:53 AM