| 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: Bitmap Indexes (again)
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.
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.
On Thu, 14 Aug 1997 03:25:45 GMT, rspies_at_minn.net (Rob Spies) wrote:
>Pages 380-381 of Advanced Oracle Tuning and Administration from Oracle
>Press states the following:
>
>To enable bitmap indexes in Oracle7.3.2, you should add the following
>lines to your database's init.ora file:
>
>event = "10111 trace name context forever"
>event = "10112 trace name context forever"
>event = "10114 trace name context forever"
>
>
>
>Rob Spies
>rspies_at_minn.net
>
>
>---
>"Andreas Hess" <ahess_at_truworths.co.za> wrote:
>
>>I'm getting a little frustrated with this wonderful feature...
>>We were running Oracle 7.3.2.1.0 on AIX. Oracle informed
>>us that bitmap indexes are only available from 7.3.2.2.
>>( so close, yet so far).
>>We upgraded to 7.3.2.3.0 (and yes, I did set compatible = 7.3.2.3.0).
>>The moment of truth:
>>CREATE BITMAP INDEX TEST ON TEST_TABLE(INDEX_COLUMN);
>>ORA-00901: invalid CREATE command
>>Let me guess - we need 7.3.2.3.1 ...?
>>Any help will be appreciated - thanks...
>>Andreas Hess
>>Oracle DBA
>
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Bethesda MD
http://govt.us.oracle.com/ -- downloadable utilities
 |
 |