Bitmapped indexes not enabled in Oracle XE

Question

I am using Oracle 10g XE (express edition). If I try to create a bitmap index, I get an error

ORA-00439 feature not enabled: Bit mapped Indexes

How do I solve this problem and create a bitmap index?

Answer 1

The online documentation includes a Licensing guide. This says:

Feature                                |  Availability
---------------------------------------+--------------
Bitmapped index, bitmapped join index  |  No

Find out more.

The point being, Express Edition is free and consequently doesn't come with all the features of Oracle's paid for databases.

Answer 2

It is possible to see the status of the bitmap feature by using the following query:

select * from V$OPTION WHERE PARAMETER = 'Bit-mapped indexes';


PARAMETER                                   VALUE                    CON_ID
------------------------------------------- ------------------------ ----------
Bit-mapped indexes                          TRUE                      0

I just checked the documentation because I run into the same error. Depending on the edition this feature is anabled or not:

• Express Edition: FALSE
• Standard Edition: FALSE
• Enterprise Edition: TRUE