What is the rule for using different types of compression on different partitions of a single table
stored on an Exadata Storage Server?
A.
All partitions must either be compressed or uncompressed.
B.
All partitions must use either OLTP compression or Hybrid Columnar Compression.
C.
Any partition can use any type of compression, regardless of the compression of other
partitions.
D.
You cannot mix compression types among partitions of the same table.
Explanation:
Note 2: Oracle supports enabling any type of table compression at the partition or sub-partition
level. An OLTP application, therefore, can store historical data in partitions with Archive
Compression, while active data remains in partitions with OLTP Table Compression.
http://docs.google.com/viewer?a=v&q=cache:5Ba7DpH4aSIJ:www.oracle.com/technetwork/middle
ware/bi-foundation/ehcc-twp-131254.pdf+Exadata+Storage+Server+compression+on+different+partitions+All+partitions+must+
use+either+OLTP+compression+or+Hybrid+Columnar+Compression&hl=en&gl=in&pid=bl&srcid=
ADGEEShHOE7yI9ggVnWONVw0jAxTh57P_07j_yj298frctNhZ1lgdcqdPAVENAuDmxaDP2WU6_
TuAfb6BdwP9pADcMxognuPKygvWrvIsC9cQFin_JuIsFE6Y7-ZLMV1spwle118PXIc&sig=AHIEtbS-SANt3sk4OoCSnN7mprxM-QOgvw