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 -----------------------------------
