Quantcast
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

*
To prove you're a person (not a spam script), type the security word shown in the picture. Click on the picture to hear an audio file of the word.
Click to hear an audio file of the anti-spam word

Comment moderation is enabled. Your comment may take some time to appear.