Primary Keys Editor (Oracle)

From DBArtisan
Jump to: navigation, search

Go Up to Oracle Object Editors

The Primary Keys Editor lets you manage columns, basic properties, storage and space, and partitions for a primary key.

To edit primary key

  1. Open an editor on the primary key. For details, see Opening an Object Editor.
  2. Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:
Tab Settings and tasks


Displays a listing of the columns making up the primary key. Optionally, you can:

Click the New button to add a new column to the index.

Select an existing column and click the Delete button to delete that column from the index.


Lets you work with settings in the following categories:

Enforcing Index

Lets you view User Defined, Index Owner, and Index Name properties.


Lets you work with No Sort (only available if Enabled is set), Logging (YES, NO, or NONE), Reverse (disabled if No Sort is enabled), Validate, Deferrable, Deferred (IMMEDIATE or DEFERRED and only enabled if Deferrable is enabled), Enabled, Cascade (disabled if Enabled is set), Rely and Update Date properties.


Lets you work with settings in the following categories:

Data Block Storage

Lets you specify Tablespace, Percent Free, Initial Transactions, and Max Transactions values. NOTE: You should never place primary keys on the SYSTEM tablespace.


Displays Initial Extent, Next Extent, Percent Increase, Minimum Extents and Maximum Extents values.


Lets you specify Freelists and Freelist Groups values.

Buffer Pool

Lets you specify a buffer pool.


Lets you work with settings in the following categories:

Space Utilization

Lets you view Size and Blocks properties.


Lets you view Index Level, Distinct Keys, Cluster Factor, Leaf Blocks, Leaf Blks/Key, and Data Blks/Key properties.


If the primary key is currently partitioned, this tab displays the following partition details:


Lets you view the Locality (Global/Local), Alignment (Prefixed/Non-Prefixed), Partition Type (RANGE or HASH), and Subpartition type properties.

Click the Edit Partition button to edit partition details. or more information, see Partitioning Oracle indexes, primary keys, and unique keys.

Click the Drop Partition button to revert to an unpartitioned primary key.

Use the Partition Commands menu items to initiate object actions. For details, see the following topics: Allocate Extent Analyze Coalesce Deallocate Unused Space Mark Unusable - opens a dialog that lets you select one or more partitions to be marked as unusable. Rebuild - opens a dialog that lets you select a partition to be rebuilt. Split - opens a dialog that lets you divide a single partition into two partitions. You can split partitions if a single partition is causing maintenance problems because it is too large.


Displays partitioning columns.

Partition Definitions

Displays details for each partition.

If the primary key is not currently partitioned, you can click the Convert To Partitioned button to partition the primary key. For more information, see Partitioning Oracle indexes, primary keys, and unique keys.

DDL View

For details on using this tab, see Viewing the SQL/DDL for an Object.

3. When finished, you can submit your changes. For details, see Previewing and Submitting Object Editor Changes.