Increase partition range

Hi,

We have a table sales (partitioned by range), and our partitions looks like the following.

PARTITION_NAME   TABLESPACE_NAME                HIGH_VALUE
------------------------------ ------------------------------ ---
P200506   	TSSALES_2005        TO_DATE('2004-08-29 00:00:00'
P200507   	TSSALES_2005        TO_DATE('2004-10-03 00:00:00'
P200508   	TSSALES_2005        TO_DATE('2004-10-31 00:00:00'
P200509   	TSSALES_2005        TO_DATE('2004-11-28 00:00:00'
P200510   	TSSALES_2005        TO_DATE('2005-01-02 00:00:00'
P200511   	TSSALES_2005        TO_DATE('2005-01-30 00:00:00'
P200512   	TSSALES_2005        TO_DATE('2005-02-27 00:00:00'
P200601   	TSSALES_2006        TO_DATE('2005-04-02 00:00:00'

Partition P200601 should have high value of '2005-04-03 00:00:00'.

Each monthly partition can have values less than first date of next fiscal month.By mistake We have created the current fiscal month partition with the range less than '2005-04-02 00:00:00' (last date of current fiscal month).But the high value must be '2005-04-03 00:00:00' (first date of next fiscal month).

We know that we can merge last two month partition and split it again with perfect range. Since this table is highly accessible, we want to increase the range of last partition without affecting DMLs.

Is there any way to increase the range of last month partition without affecting DMls.

Thanks In advance. Received on Tue Mar 01 2005 - 00:43:23 CST