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: 4580
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: 68707
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: 68707
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 messageGo to next message
Michel Cadot
Messages: 68707
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No.

Regards
Michel
Re: ORA-00439: feature not enabled: Bit-mapped indexes [message #635275 is a reply to message #564241] Thu, 26 March 2015 00:29 Go to previous messageGo to next message
ramanakakarla
Messages: 2
Registered: March 2015
Location: India
Junior Member

Oracle Expression (OE) Edition is the cheapest edition compared to Standard, Enterprise & Personal. OE will not have enough Oracle APIs itself, for instance WM_CONCAT is one of Oracle API function which is not available as part of OE edition. Better not use if you need more capabilities.
Re: ORA-00439: feature not enabled: Bit-mapped indexes [message #635277 is a reply to message #635275] Thu, 26 March 2015 01:53 Go to previous messageGo to next message
Littlefoot
Messages: 21821
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
"OE"? Where did that abbreviation come from? Oracle Express Edition was always known as "XE", not "OE".
Re: ORA-00439: feature not enabled: Bit-mapped indexes [message #635278 is a reply to message #635275] Thu, 26 March 2015 01:59 Go to previous messageGo to next message
Michel Cadot
Messages: 68707
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
Oracle Expression (OE) Edition


Never heard about it or do you mean Oracle Express Edition (XE) which we already talked about 3 years ago.

Quote:
for instance WM_CONCAT is one of Oracle API function which is not available as part of OE edition


You should not use anyway as this is an undocumented function for Oracle use only.

Re: ORA-00439: feature not enabled: Bit-mapped indexes [message #635495 is a reply to message #635277] Tue, 31 March 2015 01:39 Go to previous message
ramanakakarla
Messages: 2
Registered: March 2015
Location: India
Junior Member

My mistake...I should not have referred Oracle Express Edition as OE.
Previous Topic: Bind variable for date type takes longer time in a query
Next Topic: performance
Goto Forum:
  


Current Time: Thu Nov 07 16:11:49 CST 2024