Tables Editor (Oracle)

From RapidSQL
Jump to: navigation, search

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.