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.
- Follow-Ups:
- RE: bitmapped index with "parallel" OK?
- From: Bobak, Mark
- References:
- bitmapped index with "parallel" OK?
- From: Thomas Day
Other related posts:
- RE: bitmapped index with "parallel" OK?
- From: Bobak, Mark
- bitmapped index with "parallel" OK?
- From: Thomas Day