Re: How to rebuild unusable index in parallel?

"Jaap W. van Dijk" <j.w.vandijk.removethis_at_hetnet.nl> wrote in message news:8jfis01ctg6jlit3qs69qrsfhv653nr57s_at_4ax.com...
> Hi,
>
> In Oracle 9.2.0.4 on Solaris I have a table with degree DEFAULT and an
> UNUSABLE bitmap index defined on the table, also with degree DEFAULT.
> Parallel ddl has been enabled for the session.
>
> If I do a count on the table which requires a full table scan, the
> table is being read in parallel. If I execute
>
> alter index so_and_so rebuild;
>
> the table is being read noparallel. Why, and how can I force reading
> in parallel?
>
> Jaap.

Alter index ... rebuild parallel ? Received on Wed Dec 22 2004 - 09:55:31 CST