Re: Table compression experience?

From: <>
Date: Thu, 24 Jul 2008 09:54:18 -0400
Message-ID: <>

Joel, did you research it enough to find any bug #'s on this issue? I've done some basic testing with it and haven't run into this issue but I'd rather not with production either. But we're moving to



We can’t solve problems by using the same kind of thinking we used when we created them.
Albert Einstein

Joel Wittenmyer <> Sent by:
07/23/2008 11:31 PM
Please respond to

oracle-l <>
Re: Table compression experience?

I had a client with a Data Warehouse that used it on with disastrous results. They used Microstrategy as a front end. Data was occasionally and repeatably corrupted for no conceivable reason. Oracle could not explain it. When we rebuilt the tables without compression the corruption disappeared. Rebuild it again with compressin and voila, corruption. This issue alone delayed migration to a new platform for a newly merged, national conglomerate for months. I talked the merged IT department into going with Oracle instead of DB2 (an easy task) and we all (Oracle proponents) ended up with a black eye for our trouble. I am no longer with the company that supported that client as a result of their moral turpitude (nothing to do with this issue) so I don't know how / if they eventually resolved it.

Joel Wittenmyer
(Interesting last name Ben :) )

Ben Wittmeier wrote:
> Does anyone have any negative experiences in using table compression?
> The following link is what we have on it:


> Any of you guys have any warnings on its use?
> Thanks,
> Ben
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager. This message contains confidential information and
> is intended only for the individual named. If you are not the named
> addressee you should not disseminate, distribute or copy this e-mail.

This communication is for informational purposes only. It is not intended as an offer or solicitation for the purchase or sale of any financial instrument or as an official confirmation of any transaction. All market prices, data and other information are not warranted as to completeness or accuracy and are subject to change without notice. Any comments or statements made herein do not necessarily reflect those of JPMorgan Chase & Co., its subsidiaries and affiliates.

This transmission may contain information that is privileged, confidential, legally privileged, and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. Although this transmission and any attachments are believed to be free of any virus or other defect that might affect any computer system into which it is received and opened, it is the responsibility of the recipient to ensure that it is virus free and no responsibility is accepted by JPMorgan Chase & Co., its subsidiaries and affiliates, as applicable, for any loss or damage arising in any way from its use. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you.

Please refer to for disclosures relating to UK legal entities.

Received on Thu Jul 24 2008 - 08:54:18 CDT

Original text of this message