HOw do you ALTER table add partitions on a multilevel partitioned table?

Database
Enthusiast

HOw do you ALTER table add partitions on a multilevel partitioned table?

Can a multilevel partitioned table be ALTERED to have more partitions added?

I cannot find the syntax.

4 REPLIES
Enthusiast

Re: HOw do you ALTER table add partitions on a multilevel partitioned table?

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;
Khurram
Senior Apprentice

Re: HOw do you ALTER table add partitions on a multilevel partitioned table?

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.

Dieter

Enthusiast

Re: HOw do you ALTER table add partitions on a multilevel partitioned table?

Can i see what kind of data is being inserted into these partiitons?

Enthusiast

Re: HOw do you ALTER table add partitions on a multilevel partitioned table?

example :

say....

SELECT * FROM yourtablexyz

WHERE yourtablexyz.PARTITION#L2 = 1;

Cheers,