2 Replies Latest reply: Jan 31, 2013 3:08 AM by 976379 RSS

    creating an old partition in a table.

    976379
      Hi,
      i am creating an old partition in a table but getting below error. can anyone explain how can i add old partition in a table.

      alter table TAB1
      add partition TAB1_201210290000
      values less than (TO_DATE('20121029000000', 'YYYYMMDDHH24MISS'))
      tablespace TSPACE1 ;


      Error report:
      SQL Error: ORA-14074: partition bound must collate higher than that of the last partition
      14074. 00000 - "partition bound must collate higher than that of the last partition"
      *Cause:    Partition bound specified in ALTER TABLE ADD PARTITION
      statement did not collate higher than that of the table's
      last partition, which is illegal.
      *Action:   Ensure that the partition bound of the partition to be added
      collates higher than that of the table's last partition.