|Table Compression Enhancements in Oracle Database 11g Release 1 - Save space and improve performance of OLTP systems using the enhanced table compression in 11g.|
Do any of these COMPRESS options need the Advanced Compression license?
Basic compression is free. The OLTP compression is part of the Advanced Compression option. I will note this in the article.
Balraj Singh said...I test this in 220.127.116.11 and found that we can still have
COMPRESS FOR DIRECT_LOAD OPERATIONS,
COMPRESS FOR ALL OPERATIONS,
Shouldn't this all be replaced by COMPRESS FOR OLTP and mentioned in the article at top ? Pls advise.
You are meant to use COMPRESS FOR OLTP, but COMPRESS FOR ALL OPERATIONS is still a valid syntax, but it is deprecated, meaning it might be removed in a future release.