Login  Register

reclaim free space in a tablespace

Posted by Roshan on Dec 24, 2017; 3:44pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/reclaim-free-space-in-a-tablespace-tp4756.html

Oracle Database 12.1.0.2

Hi,

I have a tablespace MOBILE_DATA09. It is currently 1T full and can be extended to 2T.
MOBILE_DATATBS.PNG

It contains monthly partitions as shown in the screenshot below
MOBILE_DATAPART.PNG 

If I delete partitions older than 4 months, Oracle will leave blank records. Will these blank records consume space? should I coalesce the tablespace?

Regards,

Roshan