Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Space allocation

Space allocation

From: Badauy, Gustavo (Gustavo) <badauy_at_avaya.com>
Date: Wed, 24 Aug 2005 11:17:29 -0300
Message-ID: <446ADA05B0EF8E44BF02F7C7AD5235E8737983@bz0814avexu1.global.avaya.com>


Hi guys,  

I've a table that at one point had lots of inserts and now the table has 3.6Gb worth of space allocated. When I do a select count(*) it returns 0 rows.    

How do I release all this space allocated?  

Thanks

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Aug 24 2005 - 10:34:14 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US