Oracle Indexes for Tables and Materialized Views - Partitions Tab

The Partitions tab is used in the Oracle Index Editor for Tables and the Oracle Index Editor for Materialized Views. Use the Partitions tab to assign index columns to specific physical partitions. For each partition, you can define index partition segment attributes.

Select a Partition Type in this tab. The default selection is None. The partition types available to you vary by Oracle version and what partitioning options you have selected for the table or materialized view to which the index belongs. The various types are described in the following table. For information regarding each of these options, click on the link for the partition type.

Note: The following describes general information regarding the partition types for Oracle Indexes for Tables and Oracle Indexes for Materialized Views:

• If the table or materialized view to which the index belongs is not partitioned, then all local partition types will be unavailable. If the table or materialized view is partitioned, then the default local partition type defaults to the partitioning option selected for that table or materialized view. All other partition types are unavailable.
• For all Local partition types, the Partitions grid that displays within the Partitions tab is populated with the number of rows equal to the number of partitions for the table or materialized view to which the index belongs. If you delete or change any partitions for the table or materialized view (from the Oracle Table Editor or Oracle Materialized Views Editor), the grid will refresh to reflect those changes.
• You cannot create a local or global partitioned index on a clustered materialized view.
• Global partitioning is not available for bitmap indexes.

The following table describes the partition options available to you as a result of your partition selection in a table or materialized view:

More information:

Partition Description Dialog for Oracle Indexes for Tables and Materialized Views