Re: Index reaching max extents

From: Brian Peasland <peasland_at_edcmail.cr.usgs.gov>
Date: Tue, 14 Sep 1999 14:11:58 GMT
Message-ID: <37DE57AE.2C3F8683@edcmail.cr.usgs.gov>

If maxextents is your problem, why don't you re-create the index and set the initial extent to an appropriate size?

HTH,
Brian

Bob Fazio wrote:
>
> Tapan Trivedi <tapan.trivedi_at_abbnm.com> wrote in message
> news:37DD8954.AC7246A0_at_abbnm.com...
> > Hey guys,
> > I have an index which is reaching near its max extents
>
> alter index xxx storage(maxextents unlimited);
>
> > and I am not in
> > a position to increase the max-extents due to the restrictions posed
> > upon the system.
>
> Can you be more specific? You are the DBA I assume.
>
> > What can I do ? Will rebuilding the index solve the
> > problem ??
>
> If your restriction is a lack of space on the system, NO.
>
> >
> > Any hints ,experiences , suggestions are welcome.
> >
> > Thank you very much.
> >
> > Tapan
Received on Tue Sep 14 1999 - 09:11:58 CDT