Options for Changing and Checking the Storage Parameters 

The following main options are available:

 

You can influence the storage parameters of an object in any of the following ways:

  1. Restore the objects without any change (set all options except Check space to no)
  2. Restore the objects by collecting all extents into one extent (Option Compress extents: yes)
  3. Reduce the INITIAL extent determined by the option Compress extents so that there is as little freespace in the table as possible after restoration.
  4. Manually change current values or SAPDBA defaults (Option Change storage manually: yes)

 

Compress Extents

Default Value for NEXT

Checking Freespace

Reducing the Size of the Table or Index

Changing the Storage Parameters Manually