Re: Online index build

Hi Chuck,

Just confirming what has pretty well been said.

Your index is being treated as a functioned based index (due to the DESC) and hence can't be built/rebuilt online, in 8i.

Cheers

Richard
"Chuck" <chuckh_at_softhome.net> wrote in message news:anv67h$htghj$1_at_ID-85580.news.dfncis.de...
>
> "Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message
> news:iwEo9.48804$g9.140500_at_newsfeeds.bigpond.com...
> >
> > "Chuck" <chuckh_at_softhome.net> wrote in message
> > news:anv3h6$hn1pd$1_at_ID-85580.news.dfncis.de...
> > > Platform: Oracle 8.1.7.2 on AIX
> > >
> > > I am getting an "ora-08108 may not build or rebuild this type of index
> > > online" on the following statement. Can anyone tell me why? The only
> > > restrictions on online index builds listed in the documentation or on
> > > Metalink have to do with IOTs and parallel DML.
> >
> > Check which version of the documentation you're using. Online rebuilds
> were
> > invented in 8i and onl apply to bog-standard b*tree indexes. Not to
> reverse
> > keys, function-based or key-compressed indexes, and not to IOT secondary
> > indexes either. Most of those restrictions were lifted in 9i, so I'm
> > wondering if you are reading 9i documentation?
> >
> > Regards
> > HJR
> >
>
> I am reading the 8i documentation because the instance in question is
> running verison 8.1.7. The index is a normal b-tree index on a normal
table.
> OTS is telling me that "DESC is function based" which is hogwash. Function
> based indexes came out in verion 8. Descending columns on indexes have
been
> available since at least version 7. And people wonder why I ask questions
> here rather than of OTS. I've been dealing with them for 8 years and can
> count on one hand the number of tech. support people I've spoken too there
> that were worth the price I pay for support!
> --
> Chuck
>
>
Received on Wed Oct 09 2002 - 06:36:03 CDT