My Oracle Support Banner

Compression Is Not Working On Bulk Loads For Tables with >255 Columns (Chained Rows) Starting With 12.1.0.2.160119 (Doc ID 2263452.1)

Last updated on SEPTEMBER 20, 2018

Applies to:

Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

Tables that have > 255 columns ("wide tables") cause the row to be split into multiple row pieces, also known as a chained row.  After applying one of the following patches, compression no longer occurs for bulk loads or direct loads with chained rows:


This can lead to side effects such as the following:

Changes

 You applied one of the following (or higher) bundled patches:

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.