OracleBrains.Com header image 2

Bitmap Index in Oracle Express Edition

April 18th, 2008 by Rajender Singh · 2 Comments

Today while exporting I came to know that Oracle XE does not support Bitmap Indexes.

bitmapidx1.JPG

Then to test it out, I login into Oracle XE’s SQL*Plus console and tried to run a create bitmap index DDL sql and result was still negative as follows.

bitmapidx2.JPG 

So I was convince that it does not support Bit-mapped Indexes..


Tags: Oracle Concepts · Oracle Database

2 responses so far ↓

  • 1 DJ // May 12, 2008 at 5:57 pm

    A little confused. You hit this when you were exporting an “XE” database? That means you already have a bitmap index created in your “XE” database? Or you were exporting another database using “XE” expdp?

  • 2 Rajender Singh // May 12, 2008 at 11:42 pm

    Hi DJ,

    Actually I exported a dump from standard edition.

    Later I was importing into XE on my laptop.

    Regards,

    Raj

Leave a Comment