Xref: alice comp.databases.oracle.server:56299
Path: alice!news-feed.fnsi.net!netnews.com!news.maxwell.syr.edu!news-ge.switch.ch!serra.unipi.it!news.caspur.it!news.mclink.it!not-for-mail
From: "Fabio VITALE" <mc3356@mclink.it>
Newsgroups: comp.databases.oracle.server
Subject: ORA-901 Error creating BITMAP INDEX
Date: Wed, 7 Jul 1999 09:13:18 +0200
Organization: MC-link The World On Line
Lines: 22
Message-ID: <7luv65$l2r$1@news.mclink.it>
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2014.211
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211

Plese help.
I am not able to create a bitmap index on ana existing table from the
following statement:

CREATE BITMAP INDEX USER.EMPLOYEE_BMP
 ON USER.EMPLOYEE
 (SEX)
 TABLESPACE USER_DATA

I've Personal Oracle 7.3.3.0.0

The error returned by ORACLE is ORA-901 Invalid create command.

My documentation says that the COMPATIBLE parameter in INIT.ORA must be set
to 7.3.3 at minimum to use the CREATE BITMAP INDEX command. I've checked mi
INIT.ORA and the V$PARAMETER view and the COMPATIBLE is set to 7.3.3.

Please help!