Re: compacting tablespaces

From: Sudheer Tummala <sut_at_ordinal.micro.lucent.com>
Date: 1997/09/12
Message-ID: <3419B325.C03@ordinal.micro.lucent.com>#1/1

golob_at_raye-atm.rz.uni-frankfurt.de wrote:
>
> Hi all,
>
> I've some rather big tablespaces (>2GB) which are, due to
> several deletions of tables, indexes and clusters very fragmented
> and waste a lot of space.
>
> Is it possible to defragment tablespaces and reduce the occupied
> diskspace?
>
> Please reply to my e-mail adress too...
>
> Thanks in advance
> Thomas Golob
> golob_at_stud.uni-frankfurt.de

If you are using Oracle 7.3., I think you can coalesce adjacent fragments.

Otherwise, export the data and import it again That will solve the fragmentation problem.

Sudheer

-- 
***********************************

Received on Fri Sep 12 1997 - 00:00:00 CDT