Re: Bitmap Indexes (again)

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