3.3 Administering Exadata Hybrid Columnar Compression

Use these procedures to administer Oracle Database objects that use Exadata Hybrid Columnar Compression.

• Determining If a Table Is Compressed
  Query the *_TABLES or *_TAB_PARTITIONS data dictionary views to determine whether a table or partitioned is compressed.
• Determining Which Rows are Compressed
  When Exadata Hybrid Columnar Compression tables are updated, the rows change to a lower level of compression.
• Changing Compression Level
  You can change the compression level for a partition, table, or tablespace.
• Importing and Exporting Exadata Hybrid Columnar Compression Tables
  You can use the impdp and expdp commands to import and export Exadata Hybrid Columnar Compression tables.
• Restoring an Exadata Hybrid Columnar Compression Table
  The compressed table backup can be restored to a system that supports Exadata Hybrid Columnar Compression, or to a system that does not support Exadata Hybrid Columnar Compression.