Re: Bitmap Indexes

From: francisco.carreira <francisco.carreira_at_ine.pt>
Date: 1998/01/12
Message-ID: <69e0op$b7n$1@duke.telepac.pt>#1/1

Hi Gregory.

On WG Server there is no bitmap index feature. If you want to use bitmat index you must have Enterprise Server and not Workgroup Server as you mencioned.

Bye

Gregory Fabre wrote in message <34B0C014.CFFCC106_at_netvalley.fr>...
>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
Received on Mon Jan 12 1998 - 00:00:00 CST