Tables Editor (Oracle)

Go Up to Oracle Object Editors

The Tables Editor lets you manage columns, constraints, storage and space, and partitions for a table.

To edit a table

1. Open an editor on the table. 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 the currently defined columns in the table. For any selected column, the Property/Value list provides additional detail on that column. Available properties depend on the datatype you choose as well as on the property values you select: Virtual - indicates whether this column is defined as an Oracle virtual column. If selected, the value is provided by the calculation in the Default Value box. Datatype properties- Lets you select a type and depending on your selection, additional properties such as Scale, Width, and Unused may be available. Allow Nulls - Select this check box to allow nulls in this column. Encryption properties include Password, Salted, and EncryptionAlgorithm. Default Value - If Virtual is selected, this box lets you specify a valid Oracle column expression. Otherwise, it can contain a pseudocolumn (CURRENT_TIMESTAMP, USER, SYSDATE, or UID) or an expression. lets you choose among CURRENT_TIMESTAMP, USER, SYSDATE, and UID. Comment lets you add a comment to the column. LOB Storage settings are available for bfile, blob, clob, and nclob types. They include Segment Name, Configuration properties (Tablespace, Chunk, Percent Version, Enable Storage In Row, Cache, and Logging), and Storage properties (Initial Extent, Next Extent, Percent Increase, Minimum Extents, Maximum Extents, Free Lists, and Free List Groups). Optionally, you can:
		Select a column, and in the Property/Value list modify property values for that column.
		Click Add Column, provide a name for the new column, and set property values for the column.
		Select a column and click Delete to remove the column from the table.
Properties	Lets you work with settings in the following categories:
	Table	Lets you work with the following properties, corresponding to CREATE TABLE clauses: Cache, Row Movement, Parallel Degree, and Parallel Instances.
	Physical	Lets you view the Row Organization property. Lets you set the Logging and Table Compression properties.
Indexes	Lets you manage indexes for a table. On opening, the list of current indexes for the table is displayed. Optionally, take one of the following actions:
		Click Add to open a dialog that lets you add a new index to the table.
		Select an index and click Edit to open a dialog that lets you edit index properties.
		Select an index and click Drop to open a dialog that lets you remove the index from the table.
Constraints	Lets you manage constraints for the table. Constraints are grouped by type, under folders. Optionally take one of the following actions:
		Select a constraint type folder and click Add to open a dialog that lets you add a constraint of that type.
		Select a constraint and click Edit to open a dialog that lets you modify the constraint details.
		Select a constraint and click Drop to remove the constraint.
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 view Initial Extent, Next Extent, Minimum Extents, Maximum Extents, and Percent Increase values.
	Freelists	Lets you specify Freelists and Freelist Groups values.
	Bufferpool	Lets you specify a Buffer Pool.
IOT Properties	Lets you work with settings in the following categories:
	Ungrouped	Lets you specify an overflow segment.
	Percent Threshold	Lets you specify the percentage of space reserved for an index-organized table.
	Key Compression	Lets you enable or disable compression and provide a compression value.
Space	Lets you work with settings in the following categories:
	Space Utilization	Lets you view Size and number of Blocks.
	Row Information	Lets you view the Number of Rows, Average Row Length, and Chain Rows properties.
	Extents	Let you view the Number of Extents and Maximum Extents values.
LOB columns	Lets you work with settings in the following categories:
	LOB Column Segment and LOB Column Index	Lets you view the Segment Name, No. of Extents, Max Extents, Size, and Blocks properties.
	Segment Extents and Index Extents	Lets you view the Extent ID, File ID, Block ID and number of Blocks properties for segment and index extents.
Partition	Lets you work with table partitions
Comment	For details on using this tab, see Adding a Comment to an object.
Dependencies	For details on using this tab, see Working with Object Dependencies.
Permissions	For details on using this tab, see Working with Privileges and Permissions.
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.