Resizing the Data Files of a Tablespace 

Purpose

Choose Reorganization ® Resize data files of a tablespace to change the sizes of data files while the R/3 System is running (online). This uses the internal Oracle option ALTER DATABASE DATAFILE ... RESIZE ...

This function can be used for all tablespaces, including the SYSTEM tablespace.

Procedure

SAPDBA displays all data files of the selected tablespace, together with their current sizes. It also displays the freespace in the file system (corresponds to the maximum increase in file size allowed) and the minimum file size.

In contrast to the other types of reorganization, there is no split into two phases. No scripts are created; instead the changes in size are made directly in the data file.

Result

The changes in each tablespace are logged in the file <timestamp>.rrs . For more information, see Log Files and Their Contents.