Re: Extents

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.
>
> Thanks in advance.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

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