Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Bitmapped indexes not enabled in Oracle XE

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?

like image 771
user1391118 Avatar asked May 15 '12 16:05

user1391118


1 Answers

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.

like image 137
APC Avatar answered Sep 20 '22 22:09

APC