Re: fragmentation of a tablespace

Export the objects in the harvest202 tablespace (compress=y). Drop and recreate the harvest202 tablespace only. You will have to

        take the tablespace offline or stop the entire database first. Import the exported objects.

This can be done with the other tablespaces online and the database open if the other tablespaces aren't dependent on harvest202. Otherwise you'll have to take it down while you perform the rebuild and reload.

good luck.

ythorne_at_acs.neu.edu wrote:
>
> 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!
 

-- 
---
Allen Kirby			AT&T ITS Production Services
akirby_at_att.com			Alpharetta, GA.