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

Home -> Community -> Usenet -> c.d.o.server -> Re: bitmap index

Re: bitmap index

From: David Lane <dlane_at_cix.compulink.co.uk>
Date: Tue, 19 Jan 1999 23:49:26 GMT
Message-ID: <F5tzIE.BDD@cix.compulink.co.uk>


In article <36A5025E.4FCE2D39_at_cceb.upenn.edu>, xhu_at_cceb.upenn.edu (Xueyou Hu) wrote:

> 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
>

Have you got the "COMPATIBLE" clause set to 7.3.3 in the init.ora file?

Dave Lane (dlane_at_pt.lu) Received on Tue Jan 19 1999 - 17:49:26 CST

Original text of this message

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