<agarwalp@eeism.com> wrote in message
news:1117625652.469632.285630@g49g2000cwa.googlegr oups.com...
> I read in the Oracle 9i Concepts document, that a free space generated
> by deleting or updating of data can be used only by an insert statement
> in the same transaction as of delete/update or any insert statement
> immediately after the DML statement. So does that mean if there is no
> immediate insert statement that free space will never be used ? Please
> clarify my doubt.
>

It may be used the next time you perform an insert, depending on the state
of the free block list. Notice the word may.