I had a client with a Data Warehouse that used it on 10.2.0.3 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: _http://www.oracle.com/technology/products/bi/db/10g/pdf/twp_data_compression_10gr2_0505.pdf_Any of you guys have any warnings on its use? Thanks, BenThis 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.