Re: Space allocation

From: Sunil Bhola <oraclebhola_at_yahoo.com>
Date: Thu, 25 Aug 2005 00:14:42 -0700 (PDT)
Message-ID: <20050825071442.61992.qmail@web31602.mail.mud.yahoo.com>

Hi Gustavo,  

As you query is showing 0 rows means there is no data in your table.. So to reclaim this use truncate option. Truncate option comes up with two options - Drop Storage and Reuse Storage  

The command would be :-  

Truncate table sunil drop storage  

Regards,
Sunil Bhola  

"Badauy, Gustavo (Gustavo)" <badauy_at_avaya.com> wrote:

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

QUERIES in Oracle, Feel free to Join:  

http://groups.yahoo.com/group/oracle_expert/  

Regards,
Sunil Bhola
Oracle_Expert, Moderator                 

---

 Start your day with Yahoo! - make it your home page

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Aug 25 2005 - 02:16:58 CDT