TABLESPACE cleanup not happening after table data delete
644807Feb 3 2010 — edited Feb 8 2010Hi all
I have a partitioned table with 4 partitions all residing in a single tablespace. I populated the table with sample data and then deleted all with a simple delete statement followed by a commit. But the tablespace is still showing data from the 4 partitions under the bytes column in query below:
select segment_name, partition_name, tablespace_name, bytes
from dba_segments
where tablespace_name='tb_name'
Am I missing something here? Do I need to run some other command after delete and commit to fully flush out the data?
FYI, my system specs are:
Windows 2008 Server Standard (32-bit)
ORACLE 11.1.0.7.0