Re: bitmap index on 7.3.3

From: Michael Serbanescu <mserban_at_postoffice.worldnet.att.net>
Date: Sun, 10 May 1998 01:20:02 -0700
Message-ID: <6j3dg5$iep@bgtnsc03.worldnet.att.net>

Check the value of the INIT.ORA parameter COMPATIBLE (should be set to at least 7.3.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 Sun May 10 1998 - 03:20:02 CDT