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