reclaim space from tablespace

[Roshan]

Oracle Database 12.1.0.2
Red Hat Linux 7.1

Hi Erman,

I would like to reclaim space from the tablespace (12c database) after dropping a partition in tablespace. My production server has only 4.2T free space.

Partitions are being created monthly
partitions.PNG

If we are currently in the month of February and I drop partiions 2017-08-01,2017-09-01,2017-10-01, there will be empty free spaces at the beginning.

Will I be able to resize the datafiles?

Please advise.

Regards,

ROshan

[ErmanArslansOracleBlog]

As Oracle says:

If it is about reclaiming free space from within a tablespace where the partition was located along with other objects then it may be difficult to reclaim the space and the situation is  described in the article "How to Resize a Datafile (Doc ID 1029252.6)" at the section "Decrease Datafile Size".

[Roshan]

Can you please advise if there is any solution? Can I move the partition to another tablespace and drop it?

[ErmanArslansOracleBlog]

To remove space from a datafile, you have to have contiguous free space at the END of the datafile.  

Carefully and fully read section "2. Decrease Datafile Size" in document "How to Resize a Datafile (Doc ID 1029252.6)"..