Home » RDBMS Server » Server Administration » Problem in deallocating unused space within space
Problem in deallocating unused space within space [message #205488] Sat, 25 November 2006 03:28 Go to next message
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member
I am trying to deallocate space within a table by adopting the following steps
1-SQL>alter table HR_ATTENDANCE compute statistics;

2-select avg_space, blocks, empty_blocks
from user_tables
where table_name ='HR_ATTENDANCE'

AVG_SPACE BLOCKS EMPTY_BLOCKS
---------- ---------- ------------
4937 180 76

3-alter table HR_ATTENDANCE deallocate unused;

4-alter table HR_ATTENDANCE compute statistics;
5-repeat the step 2 and still found

AVG_SPACE BLOCKS EMPTY_BLOCKS
---------- ---------- ------------
4937 180 76
EMPTY_BLOCKS are blocks above the HWM
and when we use deallocate unused then empty_blocks above the HWM but i am still having unused blocks before and after deallocating unused space
What could be the reason?
Can anybody help me in this regard?
thanx in advance
Re: Problem in deallocating unused space within space [message #205518 is a reply to message #205488] Sat, 25 November 2006 06:27 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi

you want to adjust ur HVM. if yes go through below link ...


http://www.orafaq.com/forum/t/72906/93410/


hope this helps
Taj

let us know what happen ?
Previous Topic: to copy a database of a platform unix for windows
Next Topic: Table with a retention period
Goto Forum:
  


Current Time: Thu Dec 08 00:40:29 CST 2016

Total time taken to generate the page: 0.05577 seconds