Re: Help with Bitmap indexes

From: Dave Klinger <dklinger_at_bechtel.com>
Date: Tue, 9 Mar 1999 13:45:39 GMT
Message-ID: <36E52602.6BFBE779@bechtel.com>

Check your INIT.ORA for the COMPATIBLE parameter. Since bitmap indexes are relatively new, the COMPATIBLE parameter must be set to at least 7.3.2. If you have it set to an older version number, bitmaps won't be available.

Dave

Self Karl wrote:

> I am trying to use bitmap indexes in Oracle 7.3.2.1.0. Here are the
> parameters in the initsid.ora file.
>
> event = "10111 trace name context forever"
> event = "10112 trace name context forever"
> event = "10114 trace name context forever"
>
> This generates an error:
>
> SQL> create bitmap index supplier$bit_nation on (n_nationkey);
> create bitmap index supplier$bit_nation on (n_nationkey)
> *
> ERROR at line 1:
> ORA-00406: COMPATIBLE parameter needs to be 7.3.2.0.0 or greater
>
> can anyone help???
>
> Thanks so much,
>
> Karl
> -
Received on Tue Mar 09 1999 - 07:45:39 CST