Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> How to rebuild unusable index in parallel?
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