Oracle Tables, Materialized Views, and Materialized View Logs - Partitions Tab

The Partitions tab is used in the Oracle Table Editor, Oracle Materialized Views Editor, and the Oracle Materialized View Log Editor. Use the Partitions tab to specify physical partition values for a table, materialized view, or materialized view log. Select the Partitioning check box to display the partitioning options for this tab. The partitioning options available are described in the following table. For information about each of these options, click on the link for the partitioning option.

Partitioning Option

Oracle 10g/11g

Range

Yes

Hash

Yes

List

Yes

Composite-Hash

Yes

Composite-List

Yes