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

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to free empty_blocks

Re: How to free empty_blocks

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 05 May 2005 07:02:12 +0200
Message-ID: <e5aj71li2gmgh2ua0pvfj37gqs9p3mvdln@4ax.com> 





On Thu, 05 May 2005 04:26:45 GMT, "Randy Harris" <randy_at_SpamFree.com>
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


Received on Thu May 05 2005 - 00:02:12 CDT












Original text of this message













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