Primary Keys Editor (Oracle)

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
Columns	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.
Properties	Lets you work with settings in the following categories:
	Enforcing Index		Lets you view User Defined, Index Owner, and Index Name properties.
	Attributes		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.
Storage	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.
	Extents		Displays Initial Extent, Next Extent, Percent Increase, Minimum Extents and Maximum Extents values.
	Freelists		Lets you specify Freelists and Freelist Groups values.
	Buffer Pool		Lets you specify a buffer pool.
Space	Lets you work with settings in the following categories:
	Space Utilization		Lets you view Size and Blocks properties.
	Statistics		Lets you view Index Level, Distinct Keys, Cluster Factor, Leaf Blocks, Leaf Blks/Key, and Data Blks/Key properties.
Partition	If the primary 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. 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.
	Columns		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.