Tuning APTARE IT Analytics > Reclaiming Free Space from Oracle
  
Version 10.2.01P10
Reclaiming Free Space from Oracle
You may occasionally need to reclaim space from Oracle before additional storage can be provisioned. You can run the following script at any time to reclaim space. It examines every Oracle database file (DBF) for “white space” at the end of the file. If the script discovers more than 256 MB of white space, it re-sizes the DBF file to remove the trailing space. This white space is a result of many insertions and deletions; in addition, white space can occur if you have truncated tables or purged a lot of data.
1. Log in to the database server as aptare.
2. Go to the tools directory:
Linux: cd /opt/aptare/database/tools
Windows: cd C:\opt\oracle\database\tools
sqlplus / as sysdba
@ reclaim_aptare_tablespace
commit;
exit