Hi

well you have this error

ERROR at line 2:
ORA-14074: partition bound must collate higher than that of the last partition

because your original partition was created with somethin like
was defined as MAXVALUE on the partition key


somethin like this

CREATE TABLE monthly_sales (colspec...)
PARTITION BY RANGE (col1,col2...)
(PARTITION P_D_CLAIM_300 VALUES LESS THAN (val) TABLESPACE p1,
PARTITION P_D_CLAIM_350 VALUES LESS THAN (val2) TABLESPACE p2,
PARTITION P_D_CLAIM_max VALUES LESS THAN (MAXVALUE) TABLESPACE p3);

now you need to drop that partition

ALTER TABLE monthly_sales DROP PARTITION P_D_CLAIM_max

ALTER TABLE monthly_sales ADD PARTITION P_D_CLAIM_3600 VALUES LESS THAN (3700)

ALTER TABLE monthly_sales ADD PARTITION P_D_CLAIM_max values less than (MAXVALUE);

be sure to back up the contents of the P_D_CLAIM_max before dropping it..

Please use only one thread for posting..if you use two or more threads it will be difficult for a person to make searches on the same topic..:-)

regards
Hrishy