Re: Bitmap Index

Or you could try getting rid of one of your 'on' keywords.... ROTFL ;-)

Ingo

Ronald wrote:

> > E. Nunns wrote:
> >
> >> Anyone know anything about creating a bitmap index?
> >>
> >> I issue the following command in sqlplus:-
> >>
> >> create bitmap index xx_bitmap on on xx_table(id);
> >>
> >> The following error is display :-
> >>
> >> ORA-00901: invalid CREATE command
> >>
> >> The version of ORACLE I am using is 7.3 running under openVMS 7.1 I
> >> understood that bitmap indexes were available from 7.3 onwards?
> >>
> >> Any suggestions anyone?
> >>
> >> Thanks
> >>
> >> Elaine
> >
> >
> >
> Did you install the Parallel Query Option ? I am not 200% sure but as far as I
> remember bitmap indexes depend on PQO.
>
> best regards,
>
> --
> Ronald.
>
> ---------------------------
> http://home.wxs.nl/~ronr/RonR.html
> The best way to accelerate your computer running windows is at 9.8 m/s^2 !
Received on Mon Mar 22 1999 - 14:28:48 CET