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!

HCC compression and UPDATES

skurup2Dec 29 2011 — edited Nov 22 2012
We use HCC QH compression for older partitions and we have a requirement to update some of these older partitions. From what I read in documents, those updated records will get converted to OLTP compression format. If this is the case, how do I convert these records back to HCC QH compression.

Are there any commands to find those records changed from HCC-QH to OLTP and commands to convert them back to HCC. I am thinking of implementing a weekly mainteance process to do those steps to locate OLTP and convert to HCC-QH.

- Sreeni
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 20 2012
Added on Dec 29 2011
5 comments
1,250 views