You can also export the data. Drop the TS, and re-create, and re-import
Connor McDonald wrote in message <37ECA636.23F5_at_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 - 22:13:05 CDT
