Re: space recover for ORACLE 7

Hi !

We can rebuild the index periodically to recover the space .

Rgs
sathya
Andrew Allen <ajallen_at_mailhost.det.ameritech.net> wrote in message news:3B942A43.D669EC80_at_mailhost.det.ameritech.net...
> Antonio Martinez wrote:
> >
> > i dont know how oracle 7 do with delete records, what happend with
space?
> > can i recover this??
>
> 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 - 12:33:27 CEST