Re: Index MAXEXTENTS change

From: Richard Foote <richard.foote_at_tbigpond.nospam.com>
Date: Mon, 14 Jun 2004 13:50:00 GMT
Message-ID: <c2izc.27180$sj4.26112@news-server.bigpond.net.au>

"Mike Coldewey" <No_Spam4m_coldewey_at_hotmail.com> wrote in message news:cak7pj$gui_at_dispatch.concentric.net...
> If I alter an index
> alter index <indexname> storage (MAXEXTENTS nnn);
>
> Do I need to drop and rebuild the index before it can be used?
> Do I need to do so before altering the index?
>
> Thanks
> Mike
>

Hi Mike,

No, you can change the maxextents of an index on the fly.

However, I would strongly suggest the use of Locally Managed Tablespaces (see the archives for details of all the advantages) whereby this question becomes redundant as all objects have maxextents set to unlimited (except RBS but that's a different story).

So "yes" you can change the maxextents but "no", you shouldn't really be asking.

Cheers

Richard Received on Mon Jun 14 2004 - 08:50:00 CDT