Home » RDBMS Server » Performance Tuning » ORA-00439: feature not enabled: Bit-mapped indexes
ORA-00439: feature not enabled: Bit-mapped indexes [message #65013] Mon, 29 March 2004 14:57 Go to next message
Sunil Bassi
Messages: 28
Registered: June 2003
Junior Member
Hi ,
I am having Oracle 9i relaese 2 on my db server. I am getting the following error every time I try to create a bitmap index:-
ORA-00439: feature not enabled: Bit-mapped indexes

I have queried the v$option table .Here the value of parameter Bit-mapped indexes is FALSE.

The result of v$version is :-
Oracle9i Release 9.2.0.1.0 - 64bit Production
PL/SQL Release 9.2.0.1.0 - Production
CORE 9.2.0.1.0 Production
TNS for Solaris: Version 9.2.0.1.0 - Production
NLSRTL Version 9.2.0.1.0 - Production

Actually when we created the database our installation was halted . so we manually created the database using Create database commnad.

How can we enable the BITMAP Index Feature now.
Pls help.

Regds
Sunil Bassi
Re: ORA-00439: feature not enabled: Bit-mapped indexes [message #65014 is a reply to message #65013] Mon, 29 March 2004 19:56 Go to previous messageGo to next message
Frank Naude
Messages: 4420
Registered: April 1998
Senior Member
Hi,

Are you using Oracle Standard Edition? Bit-mapped indexes are only available with Enterprise Edition or Personal Edition.

Best regards.

Frank
Re: ORA-00439: feature not enabled: Bit-mapped indexes [message #65016 is a reply to message #65014] Mon, 29 March 2004 22:38 Go to previous messageGo to next message
Sunil Bassi
Messages: 28
Registered: June 2003
Junior Member
yeah We r using Standard Edition....Is there any way to use BITMAP indexes with standard edition. If not then how do we update to the enterprise edition. Do we again need to create a Database ?

Regds
Sunil Bassi
Re: ORA-00439: feature not enabled: Bit-mapped indexes [message #65033 is a reply to message #65016] Thu, 01 April 2004 11:11 Go to previous messageGo to next message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
You need Enterprise or Personal edition to create Bitmap Indexes, as Frank said. You can upgrade from Standard to Enterprise by export/import . Precreate the database using Enterprise edition,export from Standard and import into Enterprise.

-Thiru
Re: ORA-00439: feature not enabled: Bit-mapped indexes [message #405216 is a reply to message #65033] Wed, 27 May 2009 01:15 Go to previous messageGo to next message
anwar786
Messages: 25
Registered: May 2009
Location: bangalore
Junior Member
this my database
Oracle Database 10g Release 10.2.0.1.0 - Production
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

i also cannot
create bitmaps
run rebuild online
& colesce as well

in v$option
Bit-mapped indexes FALSE
Online Index Build FALSE
Coalesce Index FALSE

what is the problem?
ORA-00439: feature not enabled: Bit-mapped indexes [message #405217 is a reply to message #65033] Wed, 27 May 2009 01:17 Go to previous messageGo to next message
anwar786
Messages: 25
Registered: May 2009
Location: bangalore
Junior Member
also how to know which edition 10g is working on
Re: ORA-00439: feature not enabled: Bit-mapped indexes [message #405239 is a reply to message #405216] Wed, 27 May 2009 02:50 Go to previous messageGo to next message
Michel Cadot
Messages: 59750
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you read the topic before asking?
Frank Naude wrote on Tue, 30 March 2004 03:56
Hi,

Are you using Oracle Standard Edition? Bit-mapped indexes are only available with Enterprise Edition or Personal Edition.

Best regards.

Frank

Regards
Michel
Re: ORA-00439: feature not enabled: Bit-mapped indexes [message #405251 is a reply to message #405216] Wed, 27 May 2009 03:21 Go to previous messageGo to next message
anwar786
Messages: 25
Registered: May 2009
Location: bangalore
Junior Member
thank you man but te reason i asked again was tat i am using 10g it has 5 editions so i don know which all support bitmap,online,coalesce etc.

also is there any option at all to turn on?????????
Re: ORA-00439: feature not enabled: Bit-mapped indexes [message #405254 is a reply to message #405251] Wed, 27 May 2009 03:39 Go to previous messageGo to next message
Michel Cadot
Messages: 59750
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Buy Entreprise Edition.

Regards
Michel
Re: ORA-00439: feature not enabled: Bit-mapped indexes [message #564241 is a reply to message #65013] Wed, 22 August 2012 05:52 Go to previous messageGo to next message
raveendran_p
Messages: 1
Registered: August 2012
Junior Member
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Product

I am using this version.
In this version also I am not able to create a bitmap index

Can you please any one help me.Is this any way to create a bitmap index in this Express Edition

Thanks in Advance
Re: ORA-00439: feature not enabled: Bit-mapped indexes [message #564247 is a reply to message #564241] Wed, 22 August 2012 06:19 Go to previous message
Michel Cadot
Messages: 59750
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No.

Regards
Michel
Previous Topic: Frequent changed table stats problem
Next Topic: restart database after increase the db_cache_size?
Goto Forum:
  


Current Time: Sun Nov 23 09:05:11 CST 2014

Total time taken to generate the page: 0.12803 seconds