All Forums Database
nazygholizadeh 6 posts Joined 11/10
08 Oct 2013
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.
 
 

M.Saeed Khurram 544 posts Joined 09/12
08 Oct 2013

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

dnoeth 4628 posts Joined 11/04
08 Oct 2013

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

Dieter

drmkd17 54 posts Joined 10/12
12 Feb 2014

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

Raja_KT 1246 posts Joined 07/09
12 Feb 2014

example :
say....
SELECT * FROM yourtablexyz

WHERE yourtablexyz.PARTITION#L2 = 1;

 

Cheers,

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

You must sign in to leave a comment.