As part of the regular profile operations, the Data Integration Service writes profile results to the profiling warehouse and deletes results from the profiling warehouse. The indexes and base tables can become fragmented over a period of time. You need to reclaim the unused disk space, especially for Index Organized Tables in Oracle database.
Most of the profiling warehouse tables contain relatively small amount of data and you do not need to recover the tablespace and index space.
The following tables store large amounts of profile data and deleting the tables can leave the tables fragmented:
Stores the value frequencies
Stores the staged data
When you perform the tablespace recovery, ensure that no user runs a profile task. After you recover the data, update the database statistics to reflect the changed structure.