How to enbale CREATE BITMAP INDEX feature?

Adam Tadjkarimi

unread,

Oct 1, 1998, 3:00:00 AM10/1/98

to

I tried to create a bitmap index on a table, something like:

CREATE BITMAP INDEX CREDIT_$BITMAP_JOB_ID ON CREDIT_ADJUST(JOB_ID);

I get the following error message:

ORA-00439: feature not enabled: Bitmapped indexes.

any ideas how to correct this problem? Tanx!

Adam Tadj
ad...@hsltd.com

Opinions expressed or questions asked are mine not of my employer.

Piotr Kolodziej

unread,

Oct 1, 1998, 3:00:00 AM10/1/98

to

Adam Tadjkarimi wrote in message <6v0334$ro4$1...@newsin-1.starnet.net>...

>I tried to create a bitmap index on a table, something like:
>
>CREATE BITMAP INDEX CREDIT_$BITMAP_JOB_ID ON CREDIT_ADJUST(JOB_ID);
>
>I get the following error message:
>
>ORA-00439: feature not enabled: Bitmapped indexes.
>
>any ideas how to correct this problem? Tanx!
>

Maybe you should set compatible = 7.3.2.0.0 or greater in init.ora ?
Default value is about 7.0.12 ...

Piotr Kolodziej
pk...@otago.gda.pl

j...@earthling.net

unread,

Oct 1, 1998, 3:00:00 AM10/1/98

to Adam Tadjkarimi

You didn't say what version of Oracle you're running. I seem to recall
that with some versions of Oracle you needed to install the Parallel
Query Option to use bitmap indexes.

Adam Tadjkarimi wrote:

> I tried to create a bitmap index on a table, something like:
>
> CREATE BITMAP INDEX CREDIT_$BITMAP_JOB_ID ON CREDIT_ADJUST(JOB_ID);
>
> I get the following error message:
>
> ORA-00439: feature not enabled: Bitmapped indexes.
>
> any ideas how to correct this problem? Tanx!
>

John Durst

unread,

Oct 2, 1998, 3:00:00 AM10/2/98

to

Do you have the plain Oracle Server Edition (fka, Workgroup Server) and
not the Oracle Enterprise Server Edition? If so, you cannot create

Adam Tadjkarimi

unread,

Oct 2, 1998, 3:00:00 AM10/2/98

to

Thanks for your assistance, we are runnin Oracle 8.04 on P-NT4.0.

Adam Tadj
ad...@hsltd.com

Opinions expressed or questions asked are mine not of my employer.

j...@earthling.net wrote in message <3613C1E8...@earthling.net>...

Adam Tadjkarimi

unread,

Oct 3, 1998, 3:00:00 AM10/3/98

to

John,

Thanks for your response and I appreciate your assistance. It is from the cd
labeled “Oracle 8 Version 8.0.4.0.0 for NT” with part # A59447-01. From
that I installed the product “Oracle8 Revision 8.0.4.0.0”, could this be
“Oracle Enterprise Server Edition”? The attached booklet does not say so,
but “Oracle Enterprise Manager” is in the cd.

Regards,
Adam Tadj
ad...@hsltd.com

Opinions expressed or questions asked are mine not of my employer.

John Durst <jdu...@sky.net> wrote in message <3615111B...@sky.net>...

Steve Haynes

unread,

Oct 4, 1998, 3:00:00 AM10/4/98

to

In article <6v5mgv$58s$1...@newsin-1.starnet.net>, Adam Tadjkarimi
<ad...@hsltd.com> writes

>Thanks for your response and I appreciate your assistance. It is from the cd
>labeled “Oracle 8 Version 8.0.4.0.0 for NT” with part # A59447-01. From
>that I installed the product “Oracle8 Revision 8.0.4.0.0”, could this be
>“Oracle Enterprise Server Edition”? The attached booklet does not say so,
>but “Oracle Enterprise Manager” is in the cd.
>

You do not have the enterprise version.
Enterprise manager is not part of the enterprise version.
(confusing I know)
Steve
--
Please remove nospam from my address to Reply.