Re: 8.0.5.0.0 and bitmap-index

Hi

Oracle also told me to not use Bitmap indexes unless they are rebuilt after every insert or update. we had a case of index corruption in 8.0.6. We decided in the end to remove all bitmap indexes from the database.

cheers

Pete Finnigan
www.pentest-limited.com

In article <3bd6f795.0109120128.56220cbb_at_posting.google.com>, Harald Buesching <harald.buesching.hb_at_germany.agfa.com> writes
>We are running 8.0.5.0.0 on NT. Because the application is a kind of
>Data Warehouse system, we should use 'bitmap-indexes' and 'parallel
>Select', but Oracle turned them off 3 years ago when they installed
>the machine.
>While reading the readme.txt from the Patch 8.0.5.2.6 I discovered
>that there are lots of bugs with 'bitmap-indexes' and 'parallel
>Select'. Could it be true that you shouldn't use these features in
>8.0.5.0.0 ?
>Is 8.0.5.2.6 okay?
>After I'll get access to the machine in about 2 months I'll install
>the two features and directly afterward the patch. Some comments?

-- 
Pete Finnigan
IT Security Consultant
PenTest Limited

Office  01565 830 990
Fax     01565 830 889
Mobile  07974 087 885

pete.finnigan_at_pentest-limited.com

www.pentest-limited.com