Re: fragmentation of a tablespace

ythorne_at_acs.neu.edu writes: > I have a small database (85mg) with six tablespaces (system, rbs, temp,
> tools, users, harvest202). The harvest202 tablespace (20mg) is
> fragmented. The other tablespaces are fine.
>
> The Oracle7 Server Utility User's Guide (Export/Import Tips) recommends
> the following procedure for reducing database fragmentation:
> 1. Do a full database export (full=y) to backu up the entire db.
> 2. Re-create the database using the "create database" command.
> 3. Do a full database import (full=y) to restore the entire db.
>
> Is it possible to defrag a tablespace without exporting/importing the
> entire database?
>
> Thanks for your input!

Hi,

There are certain third party tools which will defragment the tablespace for you. Examples are TS-Reorg from Platinum. One way to reduce the fragmentation is to coalesce all the free extents in a tablespace.

If you are using Enterprise manager with Ver 7.3 RDBMS, then there is an option to coalesce all contiguous extents.

Regards

N.Prabhakar Received on Wed Nov 20 1996 - 00:00:00 CET