Composite partitioning is a partitioning technique that combines some of the other partitioning methods. The table is initially partitioned by the first data distribution method and then each partition is sub-
partitioned by the second data distribution method.
The following composite partitions are available:
For More details
SUB-PARTITIONS
Utilized most often when partition strategy does not provide small enough partition units to achieve maintenance goals. Sub-partitions further divide table based another column with partitions.
The following composite partitions are available:
- Range-hash partitioning was introduced in Oracle 8i
- Range-list partitioning was introduced in Oracle 9i
- Range-range partitioning was introduced in Oracle 11g
- List-range partitioning was introduced in Oracle 11g
- List-hash partitioning was introduced in Oracle 11g
- List-list partitioning was introduced in Oracle 11g
- Interval-range partitioning was introduced in Oracle 11g
- Interval-list partitioning was introduced in Oracle 11g
- Interval-hash partitioning was introduced in Oracle 11g
- Hash-hash partitioning was introduced in Oracle 11gR2
For More details
SUB-PARTITIONS
Utilized most often when partition strategy does not provide small enough partition units to achieve maintenance goals. Sub-partitions further divide table based another column with partitions.
