Re: Upgraded to EE, still no bitmap indexes

From: Tanel Poder <tanel_at_remove.this.peldik.com>
Date: Wed, 5 Feb 2003 05:35:57 +0100
Message-ID: <3e4086d5$1_1@news.estpak.ee>

Hello!

First, you might want to check from v$option whether it's enabled there. You will have to run catalog catproc etc. scripts again.

Since the bitmap indexes exist since 7.3, the compatible parameter shouldn't be a problem, at least when creating a simple bitmap index on one table only?

Tanel.

"tojo" <Tojo_at_hotmail.com> wrote in message news:MPG.18a9e59db22b47549896ef_at_news.t-online.de...
> Oracle 9i R2 on Win 2000 Server
>
> Hi,
>
> I did the following:
>
> - Installed Oracle 9i Standard Edition
> - Created a database
> - Upgraded Oracle 9i to Enterprise Edition (same home and all)
>
> everything is OK, I just can't create a bitmap index on the database:
>
> CREATE BITMAP INDEX IDX_CONVERSIONTYPE
> ON TBL_POWERCONVERSION_DC (CONVERSIONTYPE)
>
> Error message: ORA-00439:Function not activated: Bit-mapped indexes
>
> Anyone have an idea? Do I have to recreate the instance?
>
> Thanks
> Tom
>
Received on Tue Feb 04 2003 - 22:35:57 CST