View Single Post

   
  #1 (permalink)  
Old 02-24-2008, 01:50 PM
agarwalp@eeism.com
 
Posts: n/a
Default Free space management in Blocks

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.

Reply With Quote