ORA-00439 feature not supported

ORACLE 9i, when tring to create a bitmap index, I got error :
ORA-00439 feature not supported. Bit-mapped indexes.

What's the problem,pls advise.

Thanks
Liu Yan

please view the table v$option ,if the parameter 'Bit-mapped indexes' value is false ,you can't create bitmap index .

you need the partitioning option to create bitmap indexes. use custom installation for this.

HTH.

Bitmap Indexes are only available in Enterprise Edition. Are you using Standard Edition?

Quote:

---

Originally posted by ggnanaraj
you need the partitioning option to create bitmap indexes. use custom installation for this.

HTH.

---

Are you sure about this? AFAIK Bitmap indexes were available even before oracle introduced partitioning.
I guess is is available only in EE.

Yes, the database is standard edtion , not enterprise edition.
What can be done to let the standard edition support bitmap index, or i have to rebuild the database?

Quote:

---

Originally posted by SANJAY_G
Are you sure about this? AFAIK Bitmap indexes were available even before oracle introduced partitioning.
I guess is is available only in EE.

---

Don't know what to say...check this out... http://metalink.oracle.com/metalink/...p_id=1042674.6

Sorry, i can't get into metalink

Quote:

---

Originally posted by yanliu73
Yes, the database is standard edtion , not enterprise edition.
What can be done to let the standard edition support bitmap index, or i have to rebuild the database?

---

Std Edition will not support Bit maps, you gotta install Enterpise Edition..

Quote:

---

Originally posted by ggnanaraj
Don't know what to say...check this out... http://metalink.oracle.com/metalink/...p_id=1042674.6

---

I don't think this is valid for 9i anymore.