Re: Bitmap Indexes

Gregory Fabre wrote:
>
> Hi all,
>
> My 7.3.2.3.1 WG Server does not want to create any bitmap index :
>
> SQLWKS> CREATE BITMAP INDEX "MED_SU".idx_act_type2_bm ON
> "MED_SU"."ACTIONS" ("TYPE2")
> 2> TABLESPACE IDX_TS STORAGE ( INITIAL 1M NEXT 128K MAXEXTENTS
> UNLIMITED);
> CREATE BITMAP INDEX "MED_SU".idx_act_type2_bm ON "MED_SU"."ACTIONS"
> ("TYPE2")
> *
> ORA-00901: invalid CREATE command
>
> Is this a version problem ? Or is my command really stupid ?
> Am I missing something :-O ???
>
> --
> Gregory Fabre
> Net Valley - 33 1 46 97 21 81
> Gregory.Fabre_at_NetValley.fr

Ensure that the Parallel Query option is also installed....

Cheers

-- 
==========================================
Connor McDonald
BHP Information Technology
Perth, Western Australia
"These views mine not BHP..etc etc"

"The only difference between me and a madman is that I am not mad."