Proper space management and less fragmentation is key to the performance of a database. Fragmentation happens over time. We call a table-space fragmented when there is a lot of free space available, but they are in such small pieces that Oracle cannot use them. Whenever Oracle allocates next extent to an object, it looks for contiguous space. Coalescing the tablespace will only coalesce the free extents that are adjacent to each other. By querying theDBA_FREE_SPACEview, you can determine the extent of fragmentation in the tablespace. This article is a case study, encompassing the steps taken to reorganize a large application database. The idea here is to provide the steps and scripts that can be used to reorganize data and index (one table, many tables, or just indexes) with minimal modification to the scripts. The database used is Oracle 7.3.4 (in Oracle8i, there is the option to move tables from one tablespace to another).