Managed in the Dictionary (less than 8i)

Using the Managed in the Dictionary option, you can specify the default storage parameters for all objects created in the tablespace.

This is the default method of space management in a tablespace. It was the only method available in Oracle releases prior to release 8.1.

The Managed in the Dictionary feature contains the following fields:

Override Default Values

If this box is checked, you can edit all of the fields on the Default Storage page. If the box is not checked, the default value for each field displays and the values cannot be modified. This checkbox is only enabled during tablespace creation.

Note: If you do not enter an integral multiple of the operating system data block size when defining the size of extents, your entry is increased automatically to the next multiple. If you do not enter a value, the default value remains. If a default value has not been explicitly specified, the field contains "Default."

Extent: An extent controls how space is allocated to an object. When you specify the size for an extent, a number of contiguous Oracle blocks are assigned. For example, when you specify an extent size of 10K and the block size is 2K, then 5 Oracle blocks make up the extent.

Initial Size

Size of the first extent when an object is created. Enter the size of the initial extent. Use the unit button to specify either kilobytes or megabytes. If you do not specify a size, the default is the size of 5 Oracle database blocks.

Next Size

Size of the next allocated extent when the object needs more space to store data. Enter the size of the next extent. Use the unit button to specify either kilobytes or megabytes. If you do not specify a size, the default is the size of 5 Oracle database blocks.

Minimum Size

When an object is created, all extents will be sized using a multiple of this value.

To minimize fragmentation in the tablespace, you can set this value. Enter a value for the minimum size. If you do not specify a value, the default is 0.

Increase Size By

Percent by which each extent after the second grows over the previous extent. Enter a value for percent increase. If you do not specify a value, the default is 50.

Minimum Number

Total number of extents to be allocated when an object is created in the tablespace. Enter the minimum number of extents. If you do not specify a number, the default value is 1.

Maximum Number

Maximum number of extents that can be allocated to an object created in the tablespace.

· Unlimited: When selected, allows you to create a number of extents that is only limited by the amount of contiguous free space in a tablespace.

· Value: When selected, allows you to specify the maximum number of extents. If you do not specify a value, the default value applies. The default and maximum values depend on the data block size.

Enable Logging

· Yes: If you enable logging, redo logs are created. The operation takes longer than if you did not enable logging, but you can recover updates in the case of an unexpected failure.

· No: If you do not enable logging, operation time is shorter because no redo logs are created. Since no redo logs are created, you cannot recover your updates in the case of an unexpected failure.