Resizing the Data Files of a Tablespace (SAP Library - SAP Database Guide: Oracle (BC-DB-ORA-DBA))

Resizing the Data Files of a Tablespace

Use

You can use SAPDBA for Oracle to change the sizes of the data files of a tablespace (including the SYSTEM tablespace), using the Oracle command ALTER DATABASE DATAFILE ... RESIZE... You can perform this procedure while the SAP System is running.

Prerequisites

You have configured and started SAPDBA. Refer to Getting Started with SAPDBA.

SAPDBA logs the reorganization in Central Log reorg<DBSID>.log.

Procedure

Choose Reorganization ® Resize data files of a tablespace.

Enter Tablespace name.

This is the name of the tablespace for which you want to resize the data files.

Choose Start.

SAPDBA displays the data files of the selected tablespace.

Choose the data file to resize.

SAPDBA displays the current details for the data file.

Enter the New size for the data file.

SAPDBA automatically shows and checks the maximum file size according to the free space in the file system and the minimum file size according to the used extents inside the file.

If required, select Autoextend.

SAPDBA prompts you for the incremental and maximum file sizes used in automatic table extension:

The incremental size is the size of the new file that is automatically added to the tablespace to prevent overflow.
The maximum size is the maximum size for automatic extension of the tablespace. Beyond the maximum size, you have to extend the tablespace manually.

Enter the incremental and maximum file sizes.

For more information, see Effects of Autoextend and Resize on SAPDBA.

Choose Start and execute changes.

No scripts are created for this reorganization type.

Result

SAPDBA resizes the data files immediately. It logs the changes in the file <timestamp>.rrs. For more information, see SAPDBA Log Files and Their Contents.