Online Documentation for SQL Manager for Oracle
In an index-organized table, the data rows are held in an index defined on the primary key for the table. Oracle Database maintains the table rows, both primary key column values and non-key column values, in an index built on the primary key. Index-organized tables are therefore best suited for primary key-based access and manipulation.
The following type-specific properties can be set for Index-organized tables:
Use the edit box to specify the name of the index for this table.
Specify the percentage of space reserved in the index block for an index-organized table row, or select DEFAULT from the drop-down list.
This value must be large enough to hold the primary key. All trailing columns of a row, starting with the column that causes the specified threshold to be exceeded, are stored in the overflow segment.
Select this option to create a partitioned table.
IOT Primary Constraint
This group allows you to specify a primary key column for the index-organized table, since the primary key uniquely identifies a row.
To select a column, you need to move it from the Available list to the Selected list. Use the buttons or drag-and-drop operations to move the columns from one list to another.