-
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?
-- Dilip
-
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.
Sanjay G.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
-
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?
-
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
Last edited by ggnanaraj; 08-22-2003 at 01:32 AM.
-
Sorry, i can't get into metalink
-
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..
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
-
I don't think this is valid for 9i anymore.
Tomaž
"A common mistake that people make when trying to design something completely
foolproof is to underestimate the ingenuity of complete fools" - Douglas Adams
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|