May 13, 2016

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.