Oracle script for viewing compressed tables

Are you facing a headache when viewing compressed tables in Oracle scripts? If this is the case, the following articles will give you the corresponding solutions. The following articles mainly introduce the solution for viewing compressed tables in Oracle scripts. The following describes the specific content.

1. query whether a compressed table exists in the database.

Reference

 
 

  
  
SELECT u.name AS owner,  
  
  
o.name AS table_name  
  
  
FROM sys.tab$ t,sys.obj$ o,sys.user$ u  
  
  
WHERE BITAND (t.spare1, 131072) = 131072  
  
  
AND o.obj# = t.obj#  
  
  
AND o.owner# = u.user#;  
 
 

2. query whether the table space is compressed.

Reference

 
 

  
  
SELECT name  
  
  
FROM sys.ts$  
  
  
WHERE BITAND (flags, 64) = 64;   
 
 

The preceding content describes how to view the compressed table in the Oracle script. We hope it will help you in this aspect.