-
Tablespace size refresh
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?
Regards
CF
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|