reclaim free space in a tablespace

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

reclaim free space in a tablespace

Roshan
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
Reply | Threaded
Open this post in threaded view
|

Re: reclaim free space in a tablespace

ErmanArslansOracleBlog
Administrator
When you  truncate a partition, or when you drop a partition; the space should freed up as expected.