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