Re: fragmentation

If you are going to drop all the objects in the tablespace , you may as well drop the table space and re-create it. As far as I am aware , the alter tablespace coalesce command will only make sequential/contiguous extents into a single extent. I dont think it will make the extents in an empty tablespace coalesce into a single extent...

But then again I would like to be proved wrong on this one, I am off to test this out...

Regards

Adrian
Lothar Armbruester wrote in message
<823.327T259T12402294_at_rheingau.netsurf.de>...
>On 22-Jan-98 17:06:17 gloriath wrote:
>
>> Hello,
>
>Hello!
>
>> I want to know how to defragment a tablespace easy. Is there a command
 to
>>do this ?
>
>If you have Oracle 7.3, you can use
>
>alter tablespace your_tablespace coalesce;
>
>This will merge neighboured pieces of free space. It is most efficient,
>if you export all objects from the tablespace, then drop all objects,
>do the coalesce and finally reimport the objects.
>If you don't drop all objects, the tablespace may stay fragmented:
>
>Create tables T1, T2, T3 and T4. Then drop T2 and T4. The free space owned
>by T2 and T4 is generally not neighboured so cannot be coalesced.
>
>> Thank you.
>
>Hope that helps,
>Lothar
>
>--
>Lothar Armbrüster | lothar.armbruester_at_rheingau.netsurf.de
>Schulstr. 12 | lothar.armbruester_at_t-online.de
>D-65375 Oestrich-Winkel |
>
Received on Sun Jan 25 1998 - 00:00:00 CST