RE: bitmap indexes in 7.3.4

This IS 7.x!

>From: "Singla, Sanjeev" <SSingla_at_oxhp.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: bitmap indexes in 7.3.4
>Date: Fri, 23 Jun 2000 10:15:51 -0800
>
>This is wierd. Bitmap indexes is nothing to do with parallel query option.
>Parallel query option comes default whereas bitmap indexes options comes
>only
>in Enterprise Edition. More over, there is no separate parallel query
>option.
>It may be true for Oracle 7.x but definitely not for Oracle 8.x
>See the v$option.
>
>Anyway.
>
>-----Original Message-----
>Sent: Friday, June 23, 2000 10:43 AM
>To: Multiple recipients of list ORACLE-L
>
>
>Okay...... we figured out the problem. We have Enterprise Edition but you
>also need to have parallel query running.....
>
>as it turns out, it's academic.... the distribution (over 400,000 rows) on
>a
>
>yes/no columns is 13 rows yes, the remainder no
>
>
>
>
> >From: "Rachel Carmichael" <carmichr_at_HOTMAIL.COM>
> >Reply-To: ORACLE-L_at_fatcity.com
> >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> >Subject: bitmap indexes in 7.3.4
> >Date: Fri, 23 Jun 2000 02:15:33 -0800
> >
> >Okay, even goddesses need help sometimes :)
> >
> >I KNOW I can create bitmap indexes in 7.3.4, I've done it at other jobs.
> >But
> >for the life of me, I can't remember what it is that I need to do that I
>am
> >not already doing....
> >
> >v733_plans_enabled=true
> >compatible=7.3.4.0
> >
> >and I say "create bitmap index indexname on tablename(column)"
> >
> >and it barfs on the word bitmap.....
> >
> >so what am I doing wrong????
> >
> >THANKS!!!
> >
> >Rachel
> >________________________________________________________________________
> >Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
> >
> >--
> >Author: Rachel Carmichael
> > INET: carmichr_at_hotmail.com
> >
> >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> >San Diego, California -- Public Internet access / Mailing Lists
> >--------------------------------------------------------------------
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from). You may
> >also send the HELP command for other information (like subscribing).
>
>________________________________________________________________________
>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
>--
>Author: Rachel Carmichael
> INET: carmichr_at_hotmail.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>--
>Author: Singla, Sanjeev
> INET: SSingla_at_oxhp.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).