Re: BIT MAP INDEXES......

You must install the PQ option to get the CREATE command to function, as the prior respondent pointed out.

Tansel Ozkan wrote in message <345289E4.7E2F_at_openix.com>...
>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
>
>
Received on Mon Oct 27 1997 - 00:00:00 CST