Physical Modeling › Oracle Physical Property Editors › Oracle Table Editor › Oracle Overflow Segment Attributes Editor

Oracle Overflow Segment Attributes Editor

Open the Oracle Overflow Segment Attributes Editor by clicking on the Edit Overflow button from the Oracle Index Organized Table Dialog. Use this editor to select a tablespace for the index organized table and modify the overflow properties for that tablespace. The following describes the options for the Oracle Overflow Segment Attributes Editor:

TABLESPACE

A drop-down list box where you can select a tablespace from the current model to which you assign storage properties. If you need to edit the properties of a tablespace you select, click the button to open the Oracle Tablespace Editor.

Extents

Enter values for the following options:

INITIAL

Specifies in bytes the size of the object's first extent.

NEXT

Specifies in bytes the size of the next extent to allocate to the object.

PCTINCREASE

Specifies the percent by which the third and subsequent extents grow over the preceding extent.

MINEXTENTS

Specifies the total number of extents to allocate when the object is created.

Maxextents

Specifies the total number of extents, including the first, that Oracle can allocate for the object. Select one of the following options:

UNLIMITED

VALUE

If you select this option, enter a value in the text box.

Space Usage

Enter values for the following options:

PCTFREE

Specifies the limit Oracle should use to determine when additional rows can be added. The value of this parameter is expressed as a whole number and interpreted as a percentage.

PCTUSED

Specifies the space to be reserved for each data block for future expansion. The value of this parameter is expressed as a whole number and interpreted as a percentage.

Buffer Pool

Select this check box if you want to specify a default buffer pool. Select one of the following options:

KEEP

Puts blocks from the segment into the KEEP buffer pool.

RECYCLE

Puts blocks from the segment into the RECYCLE buffer pool.

DEFAULT

Specify DEFAULT to indicate the default buffer pool.

Number Transactions

Enter a value for the following option:

INITRANS

Specifies the initial number of concurrent update transactions allocated for data blocks.

Freelists

Enter values for the following options:

FREELISTS

For objects other than tablespaces, specify the number of free lists for each of the free list groups for the table, partition, cluster, or index.

FREE GROUPS

Specifies the number of groups of free lists for the database object you are creating.

Redo Log

Select one of the following options:

LOGGING

NO LOGGING