Parameter

Default

Meaning

ComprExt

YES

If this sum exceeds the maximum amount of free space available (for reorganization or export/import of a table or an index) or the maximum data file size (for reorganization or export/import of a tablespace), the extent is divided up into single extents so that the free space or data file size is not exceeded. In this case, the values for INITIAL and NEXT are equal, and SAPDBA sets MINEXTENTS to the number of extents required. SAPDBA also recommends that you reduce the value for NEXT after the reorganization or export/import.

The default is NO for Reorganizing a Tablespace when you use the create as select reorganization method.

SAP-NEXT

YES

Determine the default NEXT extent size using the ABAP dictionary.

(not for
export/
import)

ALL

Check the freespace for all extents.

The freespace check can sometimes be unnecessarily restrictive: SAPDBA states that there is not enough freespace, when there actually is. This occurs especially when ComprExt: No or ReduceOb: No are set.

To overcome this limitation you can select CheckExt: ONLY. This means that only the initial extent or the number of extents specified by MINEXTENTS are included in the storage space check. Other next extents are not considered by the space check.

ReduceOb

NO

Set to YES if you want SAPDBA to try automatically to reduce the size allocated to the objects during the reorganization or for an export/import. To determine the actual storage space occupied, SAPDBA uses the Oracle command ANALYZE TABLE <Name> ESTIMATE STATISTICS or ANALYZE INDEX <Name> VALIDATE STRUCTURE . Using these values and the current storage parameters, a new value is determined for the space to be allocated. If this value is smaller than the storage space allocated before the reorganization or export/import, the size of the object is reduced to this value.

Manually

NO

Change the storage parameters manually.

Set to YES to change the Oracle storage parameters – such as INITIAL , NEXT , and so on – manually.