Hybrid Columnar Compress Does Not Work With Partitioned Tables

(Doc ID 1080537.1)

Last updated on DECEMBER 01, 2011

In this Document
  Symptoms
  Cause
  Solution
  References

Symptoms

Hybrid Columnar Compress (HCC) does not work for partitioned table. It works fine for non-partitioned table. Data is loaded with SQL*Loader in direct path mode.

No HCC compression is in effect unless the table is non-partitioned or partitioned but loaded with IAS.

Various attempts including mixes of cell_partition_large_extents, with/without storage clauses, partitioned and non-partitioned, show no change.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms