Unique Keys Editor (Oracle)

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
Columns	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.
Properties	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.
	Attributes		Lets you set No Sort, Logging, Reverse, Validate, Deferrable, Deferred, Enabled, Cascade, Rely, and Update Date properties.
Storage	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.
	Extents		Lets you specify Initial Extent, Next Extent, Minimum Extents, Maximum Extents, and Percent Increase values.
	Freelists		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.
Space	Lets you work with settings in the following categories:
	Space Utilization		Displays the Size and number of Blocks properties.
	Statistics		Lets you view Index Level, Distinct Keys, Cluster Factor, Leaf Blocks, Leaf Blks/Key and Data Blks/Key settings.
	Extents		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.
Partition	If the unique key is currently partitioned, this tab displays the following partition details:
	Properties		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
	Columns		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.