Re: Reusing free space in a table

From: Alex Hudghton <alex_at_alenda.freeserve.co.uk>
Date: Fri, 24 Sep 1999 14:20:32 +0100
Message-ID: <7sftr7$ks6$1@taliesin.netcom.net.uk>

Kenneth C Stahl <BlueSax_at_Unforgettable.com> wrote in message news:37EB770F.6FD9A167_at_Unforgettable.com... I used to think that "ALTER TABLE XXXX DEALLOCATE UNUSED" was supposed to correct this, but I've never seen it work the way I expected. Does anyone else have experience on this?

I think this does the opposite of "ALTER TABLE XXXX ALLOCATE EXTENT etc...." This is used quite often with parallel server to assign extents of a table to individual instances (less contention). DEALLOCATE would allow you to get back unused extents. (unless I'm totally on the wrong track :-)) )

Alex Received on Fri Sep 24 1999 - 08:20:32 CDT