orcl8i_dba_2000
asked on
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
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
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.
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.
====================
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.
ASKER
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
Bit-mapped indexes FALSE
Can I just set this to true, or do i have to do more?
Thanks
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
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
ASKER
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
(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
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
to check if you have enterprise edition installed,
at the SQLPLUS window:
SQL>select * from v$version;
it will show you
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I was afraid I would have to do this.
Thanks for the help
Thanks for the help