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 10.2.0.1 to 220.127.116.11.0 [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 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