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.