Specifying Composite Partitioning When Creating Tables

To create a composite partitioned table, you start by using the PARTITION BY {RANGE | LIST} clause of a CREATE TABLE statement. Next, you specify a SUBPARTITION BY {RANGE | LIST | HASH} clause that follows similar syntax and rules as the PARTITION BY {RANGE | LIST | HASH} clause. The individual PARTITION and SUBPARTITION or SUBPARTITIONS clauses, and optionally a SUBPARTITION TEMPLATE clause, follow.

This section contains the following topics: