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

Home -> Community -> Usenet -> c.d.o.server -> Re: Index rebuild after unusable doesn't reuse space

Re: Index rebuild after unusable doesn't reuse space

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 12 Jan 2005 06:34:33 -0800
Message-ID: <1105540473.042652.98400@f14g2000cwb.googlegroups.com> 





Kamal, an index rebuild operation always takes new extents during the
rebuild for the data.  Only when the rebuild completes successfully is
the original allocated space released.



I ran a test using 9.2.0.5 running on AIX 5.2 where I marked an index
unusage then rebuilt it and after the rebuld the index held only the
new extent allocations.  The original allocation was freed.
HTH -- Mark D Powell --
Received on Wed Jan 12 2005 - 08:34:33 CST












Original text of this message













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