Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.icl.net!newsfeed.fjserv.net!newshosting.com!nx01.iad01.newshosting.com!news.glorb.com!postnews.google.com!z14g2000cwz.googlegroups.com!not-for-mail From: "Mark D Powell" Newsgroups: comp.databases.oracle.misc Subject: Re: How to free empty_blocks Date: 5 May 2005 12:38:20 -0700 Organization: http://groups.google.com Lines: 13 Message-ID: <1115321900.242958.77290@z14g2000cwz.googlegroups.com> References: <9ghee.841$Su7.12@newssvr31.news.prodigy.com> NNTP-Posting-Host: 192.85.50.2 Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Trace: posting.google.com 1115321904 21309 127.0.0.1 (5 May 2005 19:38:24 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Thu, 5 May 2005 19:38:24 +0000 (UTC) In-Reply-To: User-Agent: G2/0.2 Complaints-To: groups-abuse@google.com Injection-Info: z14g2000cwz.googlegroups.com; posting-host=192.85.50.2; posting-account=J7QqBQwAAABTieek3RP_669Gs2iATWzr Xref: dp-news.maxwell.syr.edu comp.databases.oracle.misc:118886 As Sybrand said the initial extent is, with all existing versions of Oracle, never dropped unless you drop the object. Empty_blocks are blocks above the High Water Mark, HWM, and as such have never held data since the table was created or last truncated. If the initial extent size of the table is too large then you need to drop and re-create it. Before you read Expert-One-On-One you need to read the DBA Administration manual to get the basics down. HTH -- Mark D Powell --