Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!news.litech.org!news.mbo.net!news.tdl.com!news.he.net!newsfeed1.easynews.com!easynews.com!easynews!sn-xit-02!sn-xit-06!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: Sybrand Bakker Newsgroups: comp.databases.oracle.misc Subject: Re: How to free empty_blocks Date: Thu, 05 May 2005 07:02:12 +0200 Organization: Posted via Supernews, http://www.supernews.com Message-ID: Reply-To: postbus@sybrandb.demon.nl References: <9ghee.841$Su7.12@newssvr31.news.prodigy.com> X-Newsreader: Forte Agent 2.0/32.652 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Complaints-To: abuse@supernews.com Lines: 13 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.misc:118874 On Thu, 05 May 2005 04:26:45 GMT, "Randy Harris" wrote: >I don't know what I am doing. I've spent hours reading the docs and "Expert >One-On-One Oracle" but can't figure it out. Can someone tell me what I need >to do to free up those empty_blocks? Sure. Drop the affected table. The initial extent of a segment is never dropped. -- Sybrand Bakker, Senior Oracle DBA