fragmentation of a tablespace
From: <ythorne_at_acs.neu.edu>
Date: 1996/11/19
Message-ID: <32923BB4.14B2_at_acs.neu.edu>#1/1
Date: 1996/11/19
Message-ID: <32923BB4.14B2_at_acs.neu.edu>#1/1
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:
Is it possible to defrag a tablespace without exporting/importing the
entire database?
Thanks for your input!
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.