Unique Keys Editor (Oracle)

From DBArtisan
Jump to: navigation, search

Go Up to Oracle Object Editors

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

To edit a unique key:

  1. Open an editor on the unique 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 index. Details include the Column name, the Datatype, and whether the definition allows Nulls. 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.


In addition to displaying basic identification information, this tablets you work with settings in the following categories:

Enforcing Index

Lets you view User-Defined, Index Owner, and Index Name settings.


Lets you set No Sort, Logging, Reverse, Validate, Deferrable, Deferred, Enabled, Cascade, Rely, and Update Date properties.


Lets you work with settings in the following categories:

Data Block Storage

Lets you choose the Tablespace Name, and specify Percent Free, Initial Transactions, and Max Transactions values.


Lets you specify Initial Extent, Next Extent, Minimum Extents, Maximum Extents, and Percent Increase values.


Free lists let you manage the allocation of data blocks when concurrent processes are issued against the cluster. Identifying multiple free lists can reduce contention for free lists when concurrent inserts take place and potentially improve the performance of the cluster. This tab lets you specify Freelists and Freelist Groups values.

Buffer Pool

Lets you select a Buffer Pool.


Lets you work with settings in the following categories:

Space Utilization

Displays the Size and number of Blocks properties.


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


The unit of space allocated to an object whenever the object needs more space. This tab lets you view Number of Extents and Maximum Extents properties.


If the unique 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. For more information, see Partitioning Oracle indexes, primary keys, and unique keys.

Click the Drop Partition button to revert to an unpartitioned unique 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 Rebuild Split


Displays partitioning columns.

Partition Definitions

Displays details for each partition.

If the unique key is not currently partitioned, you can click the Convert To Partitioned button to partition the unique 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.