| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Help with Bitmap indexes
A copy of this was sent to Dave Klinger kself_at_cs.clemson.edu
(if that email address didn't require changing)
On Tue, 9 Mar 1999 13:45:39 GMT, you wrote:
Bitmap indexes are production in release 7.3.2.3, and require the parallel query option. You should be able to create bitmap indexes without any special init.ora events (other than an appropriate COMPATIBILITY setting) with this release. With 7.3.2.1 you cannot do this.
I heard that the 'magic cookie' (the three init.ora events) enables an alpha version of bitmap indexes in earlier releases of 7.3.2. This pre-beta feature lacks the full functionality of 7.3.2.3's bitmap indexes, and is buggy. You will be much happier if you upgrade to 7.3.2.3 before using bitmap indexes.
I **strongly** recommend against using the events, particularly in a production database.
>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
>> -
>
>
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA
--
http://govt.us.oracle.com/ -- downloadable utilities
 |
 |