ORACLE 11G EXTENDED COMPOSITE PARTITIONING

posted Jan 29, 2012, 7:30 PM by Sachchida Ojha
Oracle database 11g extends composite partitioning adding the following composite partitioning methods.

1. Composite range-range partitioning : The partition method will partition data using the range method. Then for each partition, subpartition will be created using range method.

2. Composite list-range partitioning : The partition method will partition data using the list method. Then for each partition, subpartition will be created using range method.

3. Composite list-hash partitioning : The partition method will partition data using the list method. Then for each partition, subpartition will be created using hash method.

4. Composite list-list partitioning : The partition method will partition data using the list method. Then for each partition, subpartition will be created using list method.

Earth Day 2011

Comments