Hi gurus,
I have a table with more than 15 millions records. Its partitioned on range basis. The highiest value it had was 3500, and maxvalue based on the number of client facilities. Now i want to add some more partitions, and i'm getting following error. Please help me, this is on production. I've to do it before users come in. I've to add 6 more partitions to near about 11 tables like this.
I'm running oracle 9i on linux 7.1

Many thanks in advance


SQL> alter table d_XXX
add partition P_D_CLAIM_3600 VALUES LESS THAN (3700)
TABLESPACE XXXDATA01;
add partition P_D_CLAIM_3600 VALUES LESS THAN (3700)
*
ERROR at line 2:
ORA-14074: partition bound must collate higher than that of the last partition

SQL> select high_value from dba_tab_partitions where table_name='D_XXX' AND TABLE_OWNER='ABC';

HIGH_VALUE
--------------------------------------------------------------------------------
1100
1200
1300
1400
1500
1600
1700
1800
1900
2000
2100

HIGH_VALUE
--------------------------------------------------------------------------------
2200
2300
1000
2400
2500
2600
2700
2800
2900
3000
3100

HIGH_VALUE
--------------------------------------------------------------------------------
3200
3300
3400
3500
MAXVALUE

27 rows selected.

Thanks