Shrinking Databases

SAP ASE allows you to shrink databases, freeing unused space for reuse or deletion.

If SAP ASE encounters data on the portion of the database you are shrinking, that data is moved to a new location before the space is removed from the database. Once the portions to be removed are empty, the physical storage is replaced by references to a null device, making the freed space available for reuse or deletion.

Generally, you can shrink databases that are online and in use. However, in some situations, you must put SAP ASE in single user mode. See "Restrictions."

Note: The shrink database functionality is not supported on the Cluster Edition.