OLTP compression: uncompress tables
jhallApr 28 2011 — edited Sep 12 2012I have read the Oracle whitepaper and the metalink technical note about advanced compression, and neither of these covered the procedure to uncompress OLTP tables after they have been compressed. We are running an SAP system, and there is a canned procedure to uncompress tables, but I think there are better ways to do this.
Anyone who has had experience uncompressing OLTP tables, would you mind sharing your procedure/experience on how you have done this? I have some large tables I will need to uncompress, and want to do this the fastest and most efficient way. Any input is appreciated.
Thanks.