Re: Bitmap Index
From: Ronald <ronr_at_wxs.nl>
Date: Sun, 21 Mar 1999 23:23:11 +0100
Message-ID: <01HW.B31B2FDF000044360F040840_at_news.wxs.nl>
>> 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
[Quoted] Did you install the Parallel Query Option ? I am not 200% sure but as far as I remember bitmap indexes depend on PQO.
Date: Sun, 21 Mar 1999 23:23:11 +0100
Message-ID: <01HW.B31B2FDF000044360F040840_at_news.wxs.nl>
> 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
> > >
[Quoted] 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 Sun Mar 21 1999 - 23:23:11 CET