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: