Re: fragmentation of a tablespace

From: Kevin Loney <"75663,327"_at_compuserve.com>
Date: 1996/11/22
Message-ID: <3295C22F.7220_at_compuserve.com>#1/1

ythorne_at_acs.neu.edu wrote:
>
> Is it possible to defrag a tablespace without exporting/importing the
> entire database?
>

Sure:
1. Export the database (alternatively, perform User exports of the users who own objects in the Harvest tablespace - see DBA_SEGMENTS). 2a. Drop the tablespace, including contents, then re-create the tablespace. or
2b. Drop the objects in the tablespace. force the space to be coalesced by creating a single large table in the tabelspace. 3. Import the objects back into the tablespace. If you performed a full system export, you'll need to specify FROMUSER and TOUSER in your IMP command so that you only bring back objects from the users who owned objects in Harvest.

If your users are segregated by tablespace, this process is simpler.

Kevin Received on Fri Nov 22 1996 - 00:00:00 CET

This message: [ Message body ]
Next message: Kevin Merritt: "Oracle opportunities at The Geneva Companies"
Previous message: **Kim Dosa**: "Connect VB app. to Oracle DB."
In reply to: ythorne_at_acs.neu.edu: "fragmentation of a tablespace"
Next in thread: Sten E. Vesterli: "Re: Newbie sqlload question"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message