Table Partition

[amerbaig]

I want to create a table with 12 partition (for each month) then within each month's data should be categories based on a column. The column will have 5 possible values (107,108,109,110,111). I know that Composite partition is more closer solution. I have done this but my values are stored in one sub-partition. Rest of sub partition is empty. But when I give higer value of column like 300,400. Other partitions start filling. How can I control this. Please help

Amer

 

[amerbaig]

Is there any solution?

Amer

 

[kindus]

One thing is very clear. you need partitioning by range in terms of months, one each for each month. So far the possible values of a column, question is whether you want subparitioning, the answer could be "may be not". What I can see is range partitioning on date and local partition index on the column you mentioned would be the solution. But I donot exactly what you dealing with, this is just a option.

Hope it helps.