Oracle Database Discussions

Hi all,

I have a table partitioned such that the last/current partition has a HIGH_VALUE of MAXVALUE. This current partition has become rather too large and I'd like to cap it and move on to a new partition. Is there a way of achieving this without having to SPLIT the current partition as this will require twice as much space as the current partition that I'd like to end or cap, and I haven't got much space plus splitting a large partition (+150Gb) takes time
Have tried adding a new partition along the lines of :

Alter Table Test Add Partition P_Current_New Values Less Than (Maxvalue)

However since the current partition on my table has a high value of MAXVALUE, I cannot do this, I get the error:

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

Any ideas?

Thanks