My Oracle Support Banner

After Compressing A Table With More Than 255 Columns Then Its Size Is Lager (Doc ID 989484.1)

Last updated on FEBRUARY 28, 2019

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 10.2 to 11.2]
Information in this document applies to any platform.


Once that a table with more than 255 columns has been compressed, then its size is more than when it was
an uncompressed table. This happens even when there are duplicate values.

Reviewed the information by commands:

SQL> select sum(bytes)/(1024*1024) from dba_segments where SEGMENT_NAME='TABLE_NAME';
SQL> select EXTENT_ID,BLOCKS from dba_extents where SEGMENT_NAME like 'TABLE_NAME';
SQL> select pct_free,pct_used from dba_tables where table_name='TABLE_NAME';




To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.