Skip to Main Content
Forums

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!

Help to enable Advanced Compression

818314Feb 9 2011 — edited Apr 27 2011
Hi,
I'm trying to create a table using COMPRESS FOR OLTP option but when I run "alter table myTable compress for oltp;" an "invalid ALTER TABLE option" occurs.
I'm on 11gR2, my compatible value in gv$parameter is 11.2.0.0.0.
Any ideas?

Thank you.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 25 2011
Added on Feb 9 2011
#advanced-compression, #data-warehousing
5 comments
6,860 views