| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: BIT MAP INDEXES......
You need to have the parallel option linked in to get bitmapped indexes. bitmapped indexes are part of the parallel option and unless that code is physically linked into the kernel, you'll get the ora-901 invalid create error.
you need
in order to create and use bitmap indexes.
On Sat, 25 Oct 1997 20:08:04 -0400, Tansel Ozkan <tansel_at_openix.com> wrote:
>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
>> >
>> >
>> >
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Bethesda MD
http://govt.us.oracle.com/ -- downloadable utilities
NOTICE: In order to cut down on the amount of time I spend applying silly logic to email addresses like "In order to cut down on spam, remove THIS from my email" or "In order to cut down on spam, reverse my email address", etc, I will simply hit delete when that mail bounces back to me, which is what I do with spam myself.
I haven't figured out whats more time consuming for me, deleting spam or resending emails after re-reading the whole thing to figure out the algorithm to apply. Received on Sun Oct 26 1997 - 00:00:00 CDT
 |
 |