Re: Recovering space after delete

In article <34123160.1519921_at_news.cadvision.com>,

   hansenrd_at_BITEME_SPAMMERS_cadvision.com (Richard Hansen) wrote:

>>You can export the data, delete the table and import it with the
 compress=yes
>>option. Using the Enterprise Manager, this can be done by using the
 defragment
>>option.
 

>I could be wrong here, but I believe that this will only create an
>initial extent the size of the all extents used by the table. It will
>not free up unused space in any extents. This unused space will
>simply be availabe for the same table, it won't be released for use by
>other segments which use the same tablespace.

You're right. I was confused by the word compress. It indeed creates one initial extent which is as large as the sum of the existing extents. Using the Enterprise Manager, you can enter new storage parameters, enabling you to really compress the segment.

Stefan.

Name      :G.R.S. Deisz
Phone     :+31-50-5855954
E mail    :G.R.S.Deisz_at_PTT-Telecom.Unisource.NL
DISCLAIMER:This statement is not an official statement from, nor
           does it represent an official position of, PTT Telecom BV.