ORA-00439: feature not enabled: Bit-mapped indexes [message #65013] |
Mon, 29 March 2004 14:57 |
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 #405216 is a reply to message #65033] |
Wed, 27 May 2009 01:15 |
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?
|
|
|
|
|
|
|
|
|
|
|
|
|