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!