Hello,
When i delete huge data from table then High Water Mark still on the same position .
1- then deleted block still on the datafile so why ? i understand that these block is not used and it's empty so when it used ?
2- Why oracle did not reclaim these block when we delete records automatically ? and we must do that using shrink command ?
3- Why before shrink data we must enable row movement ? what the meaning of row movement . and why it's disable by default , is there any impact on performance if we enable it ?
4- i try to shrink and de-allocate space for some huge data , but still tablespace free space still same , what that mean ?
Thanks,