bitmapped index with "parallel" OK?

  • From: "Thomas Day" <tomday2@xxxxxxxxx>
  • To: "Oracle-L Freelists" <Oracle-L@xxxxxxxxxxxxx>
  • Date: Wed, 25 Oct 2006 12:31:25 -0400

Tried to send this but I never saw it on the mail list.  So I've forwarded
it.  Sorry if this ends up as a double post.

---------- Forwarded message ----------
From: Thomas Day <tomday2@xxxxxxxxx>
Date: Oct 25, 2006 12:05 PM
Subject: bitmapped index with "parallel" OK?
To: oracle-l <oracle-l@xxxxxxxxxxxxx>

I'm creating bitmapped indexes on a non-partitioned table.  If I add
"parallel" to the mix of options I get an end-of-channel and the database
takes a core dump.  If I'm creating local bitmapped indexes on a partitioned
table the parallel option is no problem.  Also, parallel does not seem to be
a problem with b-tree indexes (partitioned table or no).

I've been through the documentation and tired Google but I can't find a
definitive answer.

Is "parallel" allowed with bitmapped indexes on non-partitioned tables?

Our banner says -

Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Oracle Data
Mining options
JServer Release 9.2.0.7.0 - Production

OS is AIX.

Other related posts: