Difference between COMPRESS FOR ALL OPERATIONS and COMPRESS FOR OLTP?

Question

I went through the Oracle OLTP Table Compression documentation (11 g onwards) as well as online resources to find the syntax and came across two different versions:

COMPRESS FOR ALL OPERATIONS

and

COMPRESS FOR OLTP

The documentation I looked at did not mention the alternative syntax, so I was wondering if anyone could recognize this difference.

Thank!

Answer 1

The cynical man was mistaken.

On the OTN forums, the oracle Ace says it's just a new name for the same.

http://forums.oracle.com/forums/thread.jspa?threadID=1042141&tstart=0

The same thing is said here:

http://www.oracle-base.com/articles/11g/TableCompressionEnhancements_11gR1.php

: COMPRESS COMPRESS FOR DIRECT_LOAD OPERATIONS Oracle EE, PDF APC, .

, Basic Table Compression Oracle Database 11g Enterprise Edition (EE). OLTP Oracle Advanced , Enterprise Edition.

Answer 2

, , COMPRESS FOR ALL OPERATIONS Oracle Enterprise Edition, COMPRESS FOR OLTP (pdf) , , EE.

, COMPRESS FOR ALL OPERATIONS COMPRESS FOR DIRECT_LOAD OPERATIONS; DML, . COMPRESS FOR OLTP , ( ) DML, OLTP. , , .