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