Re: Re: Pissed off at 9iR2
Quote:
Originally posted by Tarry
Dave don't get me wrong here, but didn't you try all this out in your dev/test environemnt before upgrading your production databases. Either way you've learnt something...(I guess)
We tried a lot of things, but evidently not enough, and our test box is close-but-not-the-same as prod.
For example, it's only certain of our fact tables that we can't bitmap index-- no-one seems to know why, and it worked fine under test.
We didn't try adding/dropping columns from a compressed table, 'cos it's not part of our normal operations to do so. It's was a new development that raised the issue.
Well, you know how it is, you have to draw the line somewhere. Whatever you test, you'll have missed something like a bug in applying a bitmap index to a non-foreign keyed nullable date type column having more than 10,00 rows and more than 4 distinct values, or some crap like that.
My real problem is with lack of responsiveness from Oracle on some of these issues -- having been outstanding for more than a month, with fixes backported to other platforms, you'd think it fairly straightforward to backport to a fairly common O/S like HPUX 64bit. Bugs i can handle, but the wait for fixes is driving me crazy.
Re: Re: Pissed off at 9iR2
Quote:
Originally posted by abhaysk
?????????:confused: :confused: :confused: :confused:
Indeed.
Bug No. 2093670
Re: Re: Re: Pissed off at 9iR2
Quote:
Originally posted by slimdave
Indeed.
Bug No. 2093670
Dave :
In our DW type DB (9.2.0.3 now), we have many BIT maps, but never encountered any problems, so just amused when u said "NO LONGER USE BITMAP INDEXES"...
Indeed I need to check once more now.
Abhay.