Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
ORA-901 Error creating BITMAP INDEX
75 views
Skip to first unread message
Fabio VITALE
Jul 7, 1999, 3:00:00 AM7/7/99
to
Plese help.
I am not able to create a bitmap index on ana existing table from the
following statement:
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!
Jantah
Jul 8, 1999, 3:00:00 AM7/8/99
to
On Wed, 7 Jul 1999 09:13:18 +0200, "Fabio VITALE" <mc3...@mclink.it>
wrote:
wrote:
I ran into the exact same problem today, on Oracle 7.3.3 on Solaris. I
was able to create the index after installing the Parallel query
option. I don't know about Personal Oracle though.
HTH
--
Jan
jan...@big.hand.com
(replace big.hand with bigfoot to email Jan)
giancarlo capossela
Jul 12, 1999, 3:00:00 AM7/12/99
to Fabio VITALE
The CREATE BITMAP INDEX command is available in Enterprise Edition only.
Giancarlo Capossela
0 new messages