Re: BIT MAP INDEXES......

Are you saying that the Oracle server has to come with these options to be able
to use Bitmap Indexes? I have a book that mentions that the init.ora parameter 'compatible' to be 7.3.2 or higher as the only requirement to enable Bitmap indexing. But I haven't been able to create a bitmap index. I got the following error message:

Oracle7 Server Release 7.3.2.3.0 with the 64-bit option - Production Release
With the distributed option
PL/SQL Release 2.3.2.3.0 - Production
SQLWKS> create bitmap index bp_jobseg1 on protective(seg_joblength1); create bitmap index bp_jobseg1 on protective(seg_joblength1)

              *
ORA-00901: invalid CREATE command

Thanks..

Tansel Ozkan

Nancy Huang wrote:
>
> To be sure that your server have installed the
> " distributed, parallel query and Spatial Data options"
>
> When you login sqlplus :
>
> SQL*Plus: Release 3.3.2.0.0 - Production on Thu Oct 23 08:42:20 1997
> Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.
> Connected to:
> Oracle7 Server Release 7.3.2.2.0 - Production Release
> With the distributed, parallel query and Spatial Data options
> <--------this :)
> PL/SQL Release 2.3.2.2.0 - Production
> SQL>
> >Alistair Thomson wrote:
> >
> >> Can anyone point me in the right direction for setting up a bit map
> >> index?
> >>
> >> Are parameters required in the init.ora file? What syntax do you use to
> >> create the index?
> >>
> >> I don't have manuals other than the online help and thats not much use!
> >>
> >> Please email response to alit_at_levelv.co.uk
> >>
> >> Thanks for any help.
> >>
> >> Alistair Thomson
> >
> >
> >
Received on Sat Oct 25 1997 - 00:00:00 CDT