Re: Increase partition range

On 28 Feb 2005 22:43:23 -0800, "Veera" <veeramuthu_k_at_yahoo.com> wrote:

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

Feel free to give version and platform next time, thanks.

Any attempt to carry out a DDL on the table will fail if there is any ongoing DML on the table. So you need a (very small) service window to do the repartitioning.

So I guess the answer to your question is no.

The package DBMS_REDEFINITION does offer redefiniton of tables online, but that does not include repartitioning.

• Kenneth Koenraadt