Online Documentation for SQL Manager for Oracle

Setting overflow attributes


The Overflow Attributes tab is provided for setting up overflow attributes for the new index-organized table.

 

This tab allows you to instruct the database that index-organized table data rows exceeding the specified threshold are placed in the data segment specified within this tab.

 

New table - Setting overflow attributes

 

Overflow column

Use the drop-down list to specify a column at which to divide an index-organized table row into index and overflow portions. The primary key columns are always stored in the index. The overflow column can be either the last primary key column or any non-primary key column. All non primary key columns that follow the overflow column are stored in the overflow data segment.

 

For more information refer to the Storage attributes page.