Re: ORA-901 Error creating BITMAP INDEX

From: giancarlo capossela <gcapossela_at_icare.it>
Date: Mon, 12 Jul 1999 22:18:23 +0200
Message-ID: <378A4D8F.9FD27BE6@icare.it>

The CREATE BITMAP INDEX command is available in Enterprise Edition only.

Giancarlo Capossela

gcapossela_at_icare.it

Fabio VITALE wrote:

> 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!
Received on Mon Jul 12 1999 - 15:18:23 CDT