Re: Index reaching max extents

From: Bob Fazio <bob_fazio_at_hotmail.com.no.spam>
Date: Tue, 14 Sep 1999 00:15:33 GMT
Message-ID: <FsgD3.953$FB4.56868@news.rdc1.pa.home.com>

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 Mon Sep 13 1999 - 19:15:33 CDT