Composite partitioning

From Oracle FAQ

Jump to: navigation, search

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
Retrieved from "http://www.orafaq.com/wiki/Composite_partitioning"
Personal tools