1. The Forum has been upgraded to a modern and advanced system. Please read the announcement about this update.
  2. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

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

Discussion in 'Oracle Forms and Reports' started by goodarzi121, May 11, 2009.

  1. goodarzi121

    goodarzi121 Guest

    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. sameer

    sameer Forum Advisor

    Messages:
    105
    Likes Received:
    6
    Trophy Points:
    240
    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
             );
     
    goodarzi121 likes this.
  3. rajavu

    rajavu Forum Guru

    Messages:
    815
    Likes Received:
    52
    Trophy Points:
    610
    Location:
    @ Bangalore , India
    Check the following link for more information on split partition .
    Split Partition
     
    goodarzi121 likes this.