for those that care bug# 1666543 is the psycho bitmap count(*) error
problem.
broke since it looks like 8.0.5 and still not fixed in 8.1.7
joe
>
>Joe,
>
>I saw this same problem post on lazydba just yesterday.
>
>It was a bug that is supposedly fixed in 8.1.7, but you
>know how that goes.
>
>It apparently does not corrupt data. You probably should
>look up the details on MetaClink.
>
>Jared
>
>
>On Tuesday 17 April 2001 08:00, Joseph Testa wrote:
> > Scenario:
> >
> > AIX, 8.1.6.3.
> >
> > Cognos cube building going on.
> >
> > select count(*) from ft_sales, shows up 0 rows, its using a bitmap index
> > out of the explain plan.
> >
> > I force full table scan or force to use other bitmap index, or PK(normal
> > index) and it comes back with correct count(20+ million).
> >
> > Anyone seen anything like this before?
> >
> > thanks, joe
> >
> > _________________________________________________________________
> > Get your FREE download of MSN Explorer at http://explorer.msn.com
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Joseph Testa
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
