Re: Bitmap indexes creation

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 1997/07/15
Message-ID: <33cddcd8.87154531@newshost>#1/1

On Mon, 14 Jul 1997 16:45:12 GMT, "Bell Sygma" <ss_at_sssss.com> wrote:

>Hi.
>
>I am wondering something.
>
>Could it be possible that bitmap indexes features are not provided on every
>platform for release 7.3.2 ?
>

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.

Your sqlplus banner needs to include:

With the ..., parallel query and ... options

you need the paralle query option linked in for the create bitmap index command to be recognized.

>I am currenctly connected to both an HP box running HP/UX 9.10 and an IBM
>RS/6000 AIX/3.2, and on both platform, the CREATE BITMAP INDEX is not
>recognize by SQL/PLUS, event though every initialization parameter is set
>as describe in Oracle documentation.
>
>Thanks for anyone helping.
>
>Bruno Cipelletti
>Bell Sygma Telecom Solution
>bcid_at_sympatico.ca
>

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 Tue Jul 15 1997 - 00:00:00 CDT