Partitioning Oracle indexes, primary keys, and unique keys

From DBArtisan
Jump to: navigation, search

Go Up to Oracle Object Editors

The Add Partition wizard lets you partition an Oracle index, primary key, or unique key.

To partition an index, primary key, or unique key

  1. Open an editor on the index, primary key, or unique key. For details, see Opening an Object Editor.
  2. On the Partition tab, click Convert to Partitioned.
    Note: If the object is already partitioned, the Convert to Partitioned button is not present.
  3. Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:
Tab Settings and tasks


In addition to displaying basic identification and ownership properties, this pane lets you work with the following settings: Locality - GLOBAL or LOCAL. Alignment - displays whether this partitioned object is prefixed or non-prefixed. Partition Type - RANGE or HASH. Subpartition Type - displays the subpartition type.


For each column to be added, click New to add a column, select a Column name, and specify a Sort order.

Range Definitions (only available for a Partition Type of RANGE)

Lets you create an ordered list of partitions. For each partition, click New to open the Add Partition Definition wizard. On the Partition Definition pane, provide a Name, select a Tablespace, and enable or disable Logging. On the Storage pane, provide Data Block Storage, Extents, and Freelists property values. Click Add. The Range Definitions pane also lets you edit and remove partitions.

Hash Definitions (only available for a Partition Type of HASH)

Lets you specify a Partition method: None Number of Partitions - Specify a Number of Partitions, and then for each partition, click the New button and select a tablespace. By Partition Name - For each partition, click New, specify a Name and select a Tablespace.

4. When ready, click Finish.