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
Printable View
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?
Are you sure about this? AFAIK Bitmap indexes were available even before oracle introduced partitioning.Quote:
Originally posted by ggnanaraj
you need the partitioning option to create bitmap indexes. use custom installation for this.
HTH.
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?
Don't know what to say...check this out... http://metalink.oracle.com/metalink/...p_id=1042674.6Quote:
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.
Sorry, i can't get into metalink
Std Edition will not support Bit maps, you gotta install Enterpise Edition..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?
I don't think this is valid for 9i anymore.Quote:
Originally posted by ggnanaraj
Don't know what to say...check this out... http://metalink.oracle.com/metalink/...p_id=1042674.6