Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: bitmap index on 7.3.3
Hi
The most probable couse of this is that Oracle 7.3.3 needs paralel query option
installed to make create bitmap index work.
Sincerely
Maris
Michael Serbanescu wrote:
> 1) Check the value of the INIT.ORA parameter COMPATIBLE (should be set to at
> least 7.3.2)
>
> 2) Maybe the version of SQL*Plus that you are running does not support the CREATE
> BITMAP INDEX syntax. To verify this assumption, try to create the bitmap index using
> the Server Manager or the SQL*Worksheet utility from the Enterprise Manager (if you
> have it).
>
> Hope this helps.
>
> Michael Serbanescu
> ----------------------------------------------------------------------------------
> ocmohan_at_iname.com wrote:
> >
> > Hi gurus,
> > I have been trying to create a bitmap index on a column.
> > When I issue the CREATE BITMAP INDEX ON ... command, I get ORA-00901 - invalid
> > create statement. ORACLE documentation states that to create an index as a
> > bitmap index, use the BITMAP keyword after the CREATE word. (The SQL Reference
> > manual does not talk anything about BITMAP INDEXES though). Has anyone
> > successfully created bitmap indexes on ORACLE 7.3? Any help would be greatly
> > appreciated.
> >
> > Other information you may want to know :
> > * I have 2 test machines (Window 95), one with Personal Oracle 7.3.2 and one
> > with 7.3.4.
> > * According to ORACLE documentation, the compatibility has to be 7.3.2 or
> > higher in order to use bitmap indexes. On one machine I set compatibility to
> > 7.3.2 and on the other it is 7.3.3
> > * I also set the init parameter p_bitmap_tree_plans to true.
> > * The column I am trying to use bitmap index has a low cardinality (2 values
> > 'NAT' and 'ORG')
> >
> > Thanks in advance,
> > CM
> >
> > -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> > http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Mon May 11 1998 - 03:13:41 CDT