| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> "Deallocate Unused" not bringing down the HWM in tables
Hi All
I am trying to reclaim the wasted space (huge deletes), which are above
the HWM. I had analysed the table before and got the "empty_blocks"
details from dba_tables.
I am using the following query,
alter table tab1 deallocate unused;
and then to bring down the HWM,
alter table tab1 move tablespace AR_DATA; ---- Moved within the same
tablespace
and then I had rebuilt all the corresponding indexes.
As a last step, I had coalesced the tablespace.
Next day (because SMON is not going to clear it up immediately), I had
analyzed the tables again and got the "empty_blocks" details from
dba_tables.
When I look the empty_blocks, for some tables it has not yet released
the space.
Am I missing any steps? I searched Metalink, but it looks like I have
covered everything that needs to be.
I have one more question. To really reclaim the space, do I have to move
the table out of its own tablespace ?
Any thoughts are most welcome.
Thanks and Regards
Vidya
--
Vidya Kalyanaraman
Phone: +91 80 5108 4285
Fax:+91 80 5506749
Principal Consultant
iTech Practice
Oracle Solution Services India
PBC software Park
Level 1 and 2
No. 9 Hosur Road
Bangalore - 560 029
India
 |
 |