Physical Modeling › Oracle Physical Property Editors › Oracle Table Editor › Oracle Partition Description Dialog › Oracle LOB Parameters Dialog

Oracle LOB Parameters Dialog

The Oracle LOB Parameters Dialog allows you to set parameters for LOB storage. Open the Oracle LOB Parameters Dialog by clicking on the button in the Parameters column of the grid shown in the LOB Storage tab of the Oracle Table Editor and also the Oracle LOB Storage dialog. The following describes the options for the Oracle LOB Parameters Dialog:

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.

Freelists

Enter a value in 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

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

Buffer Pool

Select this check box if you want to specify a default buffer pool. When you select this option, select one of the following options for Buffer Pool:

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.

Extents

Enter values for the following options:

INITIAL

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

NEXT

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

PCTINCREASE

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

MINEXTENTS

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

Maxextents

Specify the total number of extents, including the first, that Oracle can allocate for the object. When you select this option, select one of the following options:

UNLIMITED

VALUE

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

Store in Row

Select one of the following options:

ENABLE

DISABLE

Cache

Select one of the following options:

CACHE

If you select this option, the Logging option is not available.

NO CACHE

CACHE READS

Logging

When you select this option, select one of the following options for Logging:

LOGGING

NOLOGGING

CHUNK

Enter a value in the text box.

FREEPOOLS

Enter a value in the text box.

Retain old version type

When you select this option, select one of the following options for Retain old version type:

Retention

PCTVERSION

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