Re: bitmap index

create bitmap index patcas_patid_bmap

   on patcas(patid)
tablespace app_indx
storage(initial 50K

                 next 50K
       pctincrease 0) ;

Try this....

Aj

Xueyou Hu wrote in message <36A5025E.4FCE2D39_at_cceb.upenn.edu>...
>hi,
>I am trying to create bitmap index to speed query, but I can't create it
>with " create bitmap index patcas_patid_bmap on patcas(patid) storage
>(initial 50K next 50K pctincrease 0) tablespace app_indx", I get a
>invalid create command message. our Oracle is 7.3.3., anybody can tell
>me why, thanks a lot.
>
>
>stanley hu
>
Received on Tue Jan 19 1999 - 18:16:33 CST