Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Bitmap Indexes

Re: Bitmap Indexes

From: Connor McDonald <mcdonald.connor.cs_at_bhp.com.au>
Date: 1998/01/07
Message-ID: <34B2FF9A.6815@bhp.com.au>#1/1

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."
Received on Wed Jan 07 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US