Re: space recover for ORACLE 7

Antonio Martinez wrote:
>
> i dont know how oracle 7 do with delete records, what happend with space?
> can i recover this??

[Quoted] No need to worry about this. As enough rows are deleted from a block to make the space used less that the pctused parameter for the table, the data block will be placed on the free list and will remain there until the pctfree value is reached. As for indexes, that is a different story. Rows are marked as deleted and the space is not reused unless all the index entries in that block (leaf block) are marked deleted or unless a new index entry "belongs", in that leaf block. for instance if a row is with the key value of 125 is marked delete and the entries in that leaf block cover the range of 101 through 354 then if a new row with a key of 126 may well use that leaf block. On the other hand if the new row has a key value of 405 then it will not use that leaf block.

aj allen Received on Tue Sep 04 2001 - 03:10:56 CEST