If you want to use Reorganize tablespace and data files (reorganization of tablespaces with data files), you should make sure that no ORACLE background processes exist. Hanging background processes can disturb the course of a tablespace reorganization because they keep database files open. While these data files can be deleted during the reorganization, the disk space from such a file is not released by the operating system until the process is no longer keeping it open.

– Storage checks: Before a reorganization, SAPDBA checks whether the object(s) for reorganization can be reimported - that is, whether enough space is available.

For complicated reorganizations, we recommend performing an offline backup of the complete database after the reorganization. A backup of the database after the reorganization should be available to enable you to quickly restore the database in case problems occur at a later time.