About Creating Range-Partitioned Tables and Global Indexes

The PARTITION BY RANGE clause of the CREATE TABLE statement specifies that the table or index is to be range-partitioned. The PARTITION clauses identify the individual partition ranges, and the optional subclauses of a PARTITION clause can specify physical and other attributes specific to a partition segment. If not overridden at the partition level, partitions inherit the attributes of their underlying table.

This section contains the following topics:

• Creating a Range-Partitioned Table

• Creating a Range-Partitioned Table With More Complexity

• Creating a Range-Partitioned Global Index