How to enable bit map indexes

I went to create a bit map index and got the following
ERROR at line 1:
ORA-00439: feature not enabled: Bit-mapped indexes

Is there an easy way to enable this feature or do I have to reinstall Oracle?

Thanks
orcl8i_dba_2000Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

anand_2000vCommented:
Check in v$option to see if the Option is installed. Also note, that this feature is not present on Oracle 8i Server, only on Oracle 8i Enterprise Edition. This is also the case for Oracle8.
anand_2000vCommented:
Problem Description:
====================  
When you try to create a bitmap index on an Oracle8 Server you receive the  following:
    ORA-00439: feature not enabled: Bit-mapped indexes      

Cause: The specified feature is not enabled.      

Action: Do not attempt to use this feature.  

Solution Description:
=====================  
You must purchase Oracle8 Enterprise Edition.  

Solution Explanation:
=====================  
The feature is not present on Oracle8 Server, only on Oracle8 Enterprise Edition (see v$option). This is also the case for Oracle 8i.  Both Bitmapped and function based indexes are not available in Standard  edition. Trying to use the fb indexes will give the same ORA-439 error.  
orcl8i_dba_2000Author Commented:
We have Oracle 8i EE, I didn't create this database or install the oracle software, but I know that we only have Oracle 8i EE.  v$option returns the following
Bit-mapped indexes                                               FALSE

Can I just set this to true, or do i have to do more?

Thanks
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

anand_2000vCommented:
Can you paste the message which comes when you connect to Oracle using SQLPLUS ? For example:


SQL*Plus: Release 8.1.7.0.0 - Production on Wed Oct 22 22:37:46 2003

(c) Copyright 2000 Oracle Corporation.  All rights reserved.


Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
orcl8i_dba_2000Author Commented:
SQL*Plus: Release 8.1.7.0.0 - Production on Wed Oct 22 12:12:13 2003

(c) Copyright 2000 Oracle Corporation.  All rights reserved.


Connected to:
Oracle8i Release 8.1.7.0.0 - Production
JServer Release 8.1.7.0.0 - Production
seazodiacCommented:
Unfortunately, Sounds like you have only Oracle Standard edition.

to check if you have enterprise edition installed,

at the SQLPLUS window:

SQL>select * from v$version;

it will show you
anand_2000vCommented:
Unfortunately you may not have installed the EE. See the difference between my posting
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
and yours
Oracle8i Release 8.1.7.0.0 - Production

Reinstall Oracle is the answer if you do have the Oracle EE CD. However remember to take a complete backup of the database before you reinstall the DB

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
orcl8i_dba_2000Author Commented:
I was afraid I would have to do this.

Thanks for the help
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.