Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OLTP compression: uncompress tables

jhallApr 28 2011 — edited Sep 12 2012
I 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.
This post has been answered by Hemant K Chitale on Apr 28 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 28 2011
Added on Apr 28 2011
3 comments
35,902 views