| Problem in deallocating unused space within space [message #205488] |
Sat, 25 November 2006 03:28  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
