Re: Bitmap Indexes on 7.3.2 on NT

From: Alex B. Danchenkov <dabr_at_leaves.spb.su>
Date: 1997/04/28
Message-ID: <01bc539d$5f105cd0$542b7dc1@dabr>#1/1

Hello
If You have Oracle Enterprise Server v.7.3.2 You can enable the Oracle Bitmap Index facility.
To enable this You should add to Your database's init.ora file the following lines:

compatible = 7.3.2.0.0

event = "10111 trace name context forever"
event = "10112 trace name context forever"
event = "10114 trace name context forever"

To create a bitmap index, use a modified version of the CREATE INDEX command, as shown in the following example:

create bitmap index EMP$BITMAP_IND on EMP ( column1 );

I hope that this helps.

Regards

---

Alex B. Danchenkov, Certified Oracle DBA ,Leaves Inc. e-mail: dabr_at_leaves.spb.su

Joe Loyer <jloyer_at_your-net.com> wrote in article <01bc51f4$d3157480$2cb182d0_at_yyy>...
> Bitmap indexes will not be available until 7.3.3 (May hopefully).
>
> Richard Bulan <richard.bulan_at_ey.com> wrote in article
> <5jjn8q$1lm_at_csu-b.csuohio.edu>...
> >
> > Any ideas why I can't create a bitmap index under NT?
Received on Mon Apr 28 1997 - 00:00:00 CDT