Can a multilevel partitioned table be ALTERED to have more partitions added?
I cannot find the syntax.
You can try the following code:
ALTER TABLE Table_Name
MODIFY PRIMARY INDEX (col1,col2,col3)
ADD RANGE BETWEEN DATE '2013-01-01' AND DATE '2013-12-31' EACH INTERVAL '1' MONTH;
If you want to add on the top level it's a simple ADD RANGE. if it's a sub-partition there's ADD RANGE#Lx.
Check the SQL DDL manual for details.
SELECT * FROM yourtablexyz