Re: Upgraded to EE, still no bitmap indexes

From: Thomas Hesse <thomas.hesse_at_team.xtra.co.nz.nospam>
Date: Wed, 05 Feb 2003 08:25:52 +1300
Message-ID: <3E4013C0.3000903@team.xtra.co.nz.nospam>

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
>

Did you just install the new software ?
What about running the scripts catalog and catproc ? When you login with SQL*PLUS did you get an message like 'Oracle9i Enterprise Edition Release ...' ? Received on Tue Feb 04 2003 - 13:25:52 CST