Re: Reusing free space in a table

I believe the deallocate is talking about what has NEVER been used (i.e. what is above the HWM) not what has been used and now have been freed by deletion activity.

A good discusion of how to avoid reorgs can be found in

'Avoiding a tablespace reorganization' by Craig A Shallahamer to be found on the Free Paper area of www.orapub.com

Regards

--
Kevin A Lewis (BOCM PAULS LTD - Animal Feed Manufacturer - Ipswich England)

                        <KevinALewis_at_HotMail.com>

The views expressed herein by the author of this document are not necessarily those of BOCM PAULS Ltd. Alex Hudghton <alex_at_alenda.freeserve.co.uk> wrote in message news:7sftr7$ks6$1_at_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 - 10:18:43 CDT