Hi,

Anyone knows how to make the tablespace size from the dba_free_space view, refresh to reflect the actual usage after housekeeping?

e.g initial tablespace size free space is 10%. After i did some housekeep and delete hundred thousands of record, the free space size remains the same. If i'm not wrong, extents were allocated to a particular table, even if i delete many records, the extents usage will still be there. Dropping a table definatley will see a new free space value for a tablespace.

If there any way i could delete all those unused extents?