Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Free space management in Blocks

Free space management in Blocks

From: <agarwalp_at_eeism.com>
Date: 1 Jun 2005 04:34:12 -0700
Message-ID: <1117625652.469632.285630@g49g2000cwa.googlegroups.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. Received on Wed Jun 01 2005 - 06:34:12 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US