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:
What is visible as the available options depends on the selected table type.
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.
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
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.