Table Compression Is Limited To 255 Columns (Doc ID 443843.1)

Last updated on MARCH 16, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.3 to 11.2.0.4 [Release 9.2 to 11.2]
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

The following statement executed against the table for Segment Compression runs without any errors, however the table remains uncompressed :

ALTER TABLE mytable MOVE COMPRESS; 

Changes

Tables which do not get compressed have more than 255 columns.

SQL> select count(*) from dba_tab_columns where table_name='MYTABLE';

  COUNT(*)
---------- 
       280

1 row selected.

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