Thanks for the reply. That is indeed the problem. In this case OTS was
correct and I was wrong. It appears the the treatment of DESC indexes
changed somewhere along the line as it was available before FBIs were, but
is now treated as a FBI. Since I need this index to return results back in
descending order, and due to the size and activity on the table it will be
impossible to build it without the online option I am going to try a
different approach. I will build the index ascending on all columns and try
use an index_desc hint on the query.
--
Chuck
"Richard Foote" <richard.foote_at_bigpond.com> wrote in message
news:3lUo9.49379$g9.142324_at_newsfeeds.bigpond.com...
> 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 - 12:34:48 CDT
