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.PNGIt 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