Extend range partition

Database

Extend range partition

Hi

I have a table with primary index on (column 1,column2,column3) and range partitioned by column4 which has date values. I have to expand and add 2012 partition. Im trying to do it but getting below error message.

ALTER TABLE Failed. 3732: The facility of altering the partitioning of a non-empty table in this case has not been implemented yet.

Is it possible to extend the range partition with an alter statement?

Here is the primary index and partition information.

PRIMARY INDEX ( col1,col2,col3)

PARTITION BY RANGE_N(col4 BETWEEN DATE '2006-01-31' AND DATE '2008-12-31' EACH INTERVAL '1' MONTH ,

DATE '2009-01-31' AND DATE '2009-12-31' EACH INTERVAL '1' MONTH ,

DATE '2010-01-31' AND DATE '2010-12-31' EACH INTERVAL '1' MONTH ,

DATE '2011-01-31' AND DATE '2011-12-31' EACH INTERVAL '1' MONTH )

Appreciate your help!

1 REPLY

Re: Extend range partition

Hi,

Please try the following code:

ALTER TABLE Table_1

MODIFY PRIMARY INDEX (col1,col2,col3)

ADD RANGE BETWEEN DATE '2012-01-01' AND DATE '2012-12-31' EACH INTERVAL '1' MONTH;

If you have already tried the above code, then please share the complete table definition.

Please let us know if your problem is reolved or not.

- Siddharth