Re: Upgraded to EE, still no bitmap indexes

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Tue, 04 Feb 2003 08:41:33 -0800
Message-ID: <3E3FED3D.D5DBD882@exesolutions.com>

tojo wrote:

> 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

What is the compatible parameter in the init.ora and/or spfile?

Daniel Morgan Received on Tue Feb 04 2003 - 10:41:33 CST