partition compression

[Roshan]

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

[ErmanArslansOracleBlog]

1)What is the partitioned column type?
2)What are the characteristics of that tableaspace named mobile_data_arc?