Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> bitmapped index with "parallel" OK?

bitmapped index with "parallel" OK?

From: Thomas Day <tomday2_at_gmail.com>
Date: Wed, 25 Oct 2006 12:05:52 -0400
Message-ID: <a8c504590610250905r4f10cc9ci50c00e1a49606772@mail.gmail.com>


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.

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Oct 25 2006 - 11:05:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US