Re: Bitmap Indexes (again)

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 1997/08/13
Message-ID: <33f1d346.7865459@newshost>#1/1

On 13 Aug 1997 13:57:58 GMT, "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

No, you just need to install the Parallel Query feature. Bitmap index code is in that component. Relink with PQ turned on and you'll have bitmap indexes.

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Bethesda MD

http://govt.us.oracle.com/ -- downloadable utilities

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Wed Aug 13 1997 - 00:00:00 CDT