Oracle Partitioning 2

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:

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