SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Compressed partitions ( BASIC ) - How to identify Data is compressed or not

zzzzzzzNov 24 2019 — edited Nov 25 2019

Hi all,

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

We have a partitioned table with compression enabled ( BASIC ). is there anyway to identify the partitions for which the data is actually compressed ?

Since Basic compression Does not compress DML data and some of the partitions are compressed later by MOVE, we are struggling to identify the compressed partitions.

Thanks in advance.

This post has been answered by Solomon Yakobson on Nov 24 2019

Jump to Answer

Added on Nov 24 2019

3 comments

2,741 views