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.