Re: Tablespace defragmentation

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Sat, 25 Sep 1999 18:38:46 +0800
Message-ID: <37ECA636.23F5@yahoo.com>

KC wrote:
>
> Hi all,
>
> I have a tablespace that has many tiny free extents and how can I
> defrag them to a large one ?
>
> Thanks,
> Kevin

You can try "alter tablespace xxx coalesce" which will defrag adjacent extents, but if you have the "holes" then these will not be coalesced...

Go to www.europa.com/~orapub . There are some very good papers on tablespace fragmentation - how to fix and how to avoid

HTH
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Sat Sep 25 1999 - 05:38:46 CDT