Richard -
Thanks for the message, and I'll look into the archives for using Locally
Managed Tablespaces.
Mike
"Richard Foote" <richard.foote_at_tbigpond.nospam.com> wrote in message
news:c2izc.27180$sj4.26112_at_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 - 09:14:48 CDT
