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: Extents

Re: Extents

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: 2000/07/18
Message-ID: <397466B6.6D5E@yahoo.com>#1/1

Nuno Souto wrote:
>
> On Mon, 17 Jul 2000 21:12:25 GMT, unixsysad_at_my-deja.com wrote:
>
> >I am looking for a way besides exporting and importing to reduce the
> >number of extents on an index. I know that you can reduce the number of
> >extents by exporting the index and then re-importing it. I am wondering
> >if there is an easier way? If anyone can help me with this it would be
> >greatly appreciated.
> >
>
> Why on earth are you exporting the index and re-importing it to
> compact? Just get the index definition out of DBA_INDEXES and
> DBA_IND_COLUMNS, construct a script to drop and re-create and be done
> with it. Or use the index re-build.
>
> Another thing: if you want to avoid fragmentation, then increase the
> initial extent to the current size of the index and make next extent
> roughly 10% of that.
>
> HTH
>
> Cheers
> Nuno Souto
> nsouto_at_nsw.bigpond.net.au.nospam
> http://www.users.bigpond.net.au/the_Den/index.html

or maybe just

alter index <blah> rebuild storage ( initial <newamount> next ... )

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse
Received on Tue Jul 18 2000 - 00:00:00 CDT

Original text of this message

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