bitmapped index with "parallel" OK?

  • From: "Thomas Day" <tomday2@xxxxxxxxx>
  • To: oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 25 Oct 2006 12:05:52 -0400

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: