RE: Free Space Not Freeing Up

From: Thapliyal, Deepak <DThapliyal_at_ea.com>
Date: Fri, 11 Aug 2000 10:56:52 -0700
Message-Id: <10586.114389@fatcity.com>

deleting does not free space .. truncate .. drop storage does ..

however if you caannot afford that .. consider de allocating extents (alter table .. deallocate) . after ur delete and then coalasce

hth
deepAk

-----Original Message-----
From: John Barron [mailto:jbarron_at_windriver.com] Sent: Friday, August 11, 2000 10:57 AM
To: Janusz, Kenneth; oaugnet; oracledba
Subject: Re: Free Space Not Freeing Up

alter tablespace <tablespace_name> coalasce;

At 12:30 PM 8/11/00 -0500, Janusz, Kenneth wrote:
>I have a tablespace of 300 MB that had 18 MB free prior to archiving and
>then deleting 120 MB worth of records. The amount of free space is still
18
>MB after deleting this amount of records. The amount of free space has not

>increased.
>
>What am I missing?
>
>TIA,
>
>Ken
>>

---

>> Kenneth C. Janusz, CPIM ADC Telecommunications/BATG
>> Oracle DBA 11311 K-tel Drive
>> Minnetonka, Minnesota 55343
>> *Voice: 952.936.8214
>> *Email: kenneth_janusz_at_adc.com
>>
>> |\ _,,,---,,_
>> ZZZzz /,`.-'`' -. ;-;;,_
>> _________________|,4- ) )-,_. ,\

(____-'_____________________________


>> 		                '---''(_/--'  `-'\_)	

>> 

>> 		"Dogs come when they're called; cats take a message and get

back to you
>later." -- Mary Bly
>>

---

>>
>>
>>
>>
>
>--------
>If you're bored, then visit the list's website: http://www.lazydba.com
>(updated daily)
>to unsubscribe, send a blank email to oracledba-unsubscribe_at_quickdoc.co.uk
>to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk

---

If you're bored, then visit the list's website: http://www.lazydba.com (updated daily)
to unsubscribe, send a blank email to oracledba-unsubscribe_at_quickdoc.co.uk to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk Received on Fri Aug 11 2000 - 12:56:52 CDT