Re: Online index build

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Wed, 9 Oct 2002 03:31:48 +1000
Message-ID: <iwEo9.48804$g9.140500@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
>Neither is the case here.
> Action is a normal table. It seems to be because of the "desc" clause on
the
> 2nd column. If I remove that it works find. Problem is I need it to be
desc.
> The docs say nothing about online index builds only working with ASC
> columns.
>
> CREATE INDEX mc.second_mem_nbr_date_idx ON mc.action
> (
> secondary_member_nbr,
> ACTION_START_DATETIME desc
> ) ONLINE PARALLEL 4
>
>
Received on Tue Oct 08 2002 - 12:31:48 CDT