List/Range Composite partition
I have a requirement to store data from different types of block of business by month and year. I am thinking of partition by block of business and subpartition mmyyyy ie. list/range composite . Does Oracle 10g has this option available? Any help/suggestion will be great.
You can have range/list partitioning, but not list/range.
In composite partitioning, partitions must allways be partitioned by range method, while subpartitions may be partitioned by list or hash method.
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
Click Here to Expand Forum to Full Width