My Oracle Support Banner

HS Compression Information Is Not Showing In DBA_TABLES For Partitioned Tables (Doc ID 1453534.1)

Last updated on FEBRUARY 21, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Oracle Database Cloud Schema 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 Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
What is the Location of compression information for partitioned and non-partitioned tables?

When we create a NON-Partition table we can find the details in DBA_TABLES about compression from column COMPRESS(ENABLED/DISABLED).
When creating a partition table with compression for query low in the table level then checking DBA_TABLES, the values for columns COMPRESS and COMPRESS_FOR are NULL.
However, compression details are found in DBA_TAB_PARTITIONS.

When we create a NON-Partition table we can find the details in DBA_TABLES about compression from column COMPRESS(ENABLED/DISABLED).

Is this a normal scenario for Partition tables?
Do you check the compression property from dba_tab_partitions in case of a Partition table?

Goal

 Enable the customer to gather information about the use of compression within the database.

Solution

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.