E-Business Suite Database For Applications Technology Stack Reclaiming Unused Space In A EBS Tablespace By Reducing The Size Of The Datafiles (Doc ID 303709.1)

Last updated on DECEMBER 10, 2024

Applies to:

Oracle E-Business Suite Technology Stack - Version 11.5.10.2 to 12.2 [Release 11.5.10 to 12.2]
Oracle Applications DBA - Version 11.5.10.2 to 12.2 [Release 11.5.10 to 12.2Cloud]
Oracle Applications Manager - Version 12.1.3 to 12.2 [Release 12.1 to 12.2Cloud]
Oracle Order Management - Version 12.2.5 to 12.2.5 [Release 12.2]
Information in this document applies to any platform.

Purpose

E-Business Suite Applications Technology Stack, Database For Applications Technology related issues

This article provides suggestions on reclaiming unused space in datafiles of applsysd tablespace in an Oracle E-Business Environment.
Although it was focused on APPLSYSD tablespace, same rules are valid for any other tablespaces.
The suggestions in this Note were collected from multiple incidents and was not tested fully in all possible apps_version/db_version combinations, however they should be applicable to all.

Scope

SCOPE & APPLICATION

For Apps DBAs looking for a method to reclaim unused space in a tablespace by reducing the size of the datafiles.

WARNING

You will be making changes to the Database.
Take a backup of the database before implementing the suggestions and test it first in either TEST or DEV Environment.
It is also suggested to shutdown all the application processes.