HI,

My table has following below details

[CODE]
Free Blocks.............................3
Total Blocks............................943
Total Bytes.............................7725056
Unused Blocks...........................3
Unused Bytes............................24576
Last Used Ext FileId....................58
Last Used Ext BlockId...................165595
Last Used Block.........................300
[/CODE}

1) I see there are total 943 blocks but used are 300 and unsed are 3 blocks and free are 3 blocks
Total is 306 blocks. Where are the remaining blocks in the table.
I assume when it does full table scan it reads till 640 blocks.
To set my HWM i need to tuncate or move the table. Is there any other way I can make my HWM come to the blocks used.

2) I did use deallocate unused keep command to free the blocks, but i see still the free blocks in the table. I had 20 free blocks and came up to 3 free blocks . but it does not go down from 3 to 1.
Does HWM come down if free blocks reduce or it stays at the total used blocks ?