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.  |