I delete all records in a table, but data file size is not reduce.
685472Mar 27 2009 — edited Mar 28 2009I use this sql get every objects size:
Select Segment_Name,Sum(bytes)/1024/1024 From User_Extents Group By Segment_Name order by Sum(bytes)/1024/1024 desc
and i found table A is empty, but it is size is still large. I think oracle mark table A's blocks as free, but not free disk space.
When i insert some record in table B, it will use table A's free blocks?