My Oracle Support Banner

Hybrid Columnar Compress Does Not Work With Partitioned Tables (Doc ID 1080537.1)

Last updated on AUGUST 04, 2018

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

To view full details, 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 a vibrant support community of peers and Oracle experts.