Table Editor Options

Previous  Index  Next  How To Use

Depending on the table type, the Oracle Table Editor has different items on the Options tab.

 

You can edit the primary key constraint name for new tables.

 

The cache checkbox tells Oracle to store data blocks of this table in the buffer cache.

 

Database Workbench supports the following Oracle table types:

Standard

Temporary

Index Organized

 

What is visible as the available options depends on the selected table type.

 

 

Standard

 

A standard Oracle table

 

The standard table has a lot of storage options. Wherever it says [default] it means it will use the Oracle default value and not include the options in the metadata statement Database Workbench generates for this table.

 

If you do not select an option, eg for Tablespace, it will not be included in the metadata statement Database Workbench generates for this table.

 

See also:

Oracle Tables

Oracle Physical Storage Options

 

Back to Top

 

 

Temporary

 

An Oracle temporary table options

 

A temporary table is a table with transaction specific rows available. If the transaction ends, the rows will be either deleted or preserved, but no other transaction will be able to see them.

 

See also: Oracle Temporary Tables

 

Back to Top

 

 

Index-Organized

Data in an Index-Organized table is stored in a B-tree like index structure according to the primary key values. Data in such a table is sorted, unlike a normal table, where the data has no specific order.

 

See also:

Oracle Index Organized Tables

Oracle Physical Storage Options

 

Back to Top