partition compression

Posted by Roshan on Jan 10, 2019; 10:17am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/partition-compression-tp7074.html

Oracle Database 12.1.0.2

Red Hat Linux 6

Hi Erman,

currently the available space on /data1 is 126 GB. I would like to compress partitioned data so that the amount of free space would increase(become more than 126 GB).

I am currently compressing the partition below
pastedImage_0.png
SQL> alter table mobile_data move partition mobile_data_2018_01 tablespace mobile_data_arc compress for oltp;

Why is the free space decreasing from 126 to 118 GB instead?

Regards,

Roshan