Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How to rebuild unusable index in parallel?

How to rebuild unusable index in parallel?

From: Jaap W. van Dijk <j.w.vandijk.removethis_at_hetnet.nl>
Date: Wed, 22 Dec 2004 10:38:58 +0100
Message-ID: <8jfis01ctg6jlit3qs69qrsfhv653nr57s@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. Received on Wed Dec 22 2004 - 03:38:58 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US