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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Rollback Segments ?

Re: Rollback Segments ?

From: John Higgins <JH33378_at_deere.com>
Date: Fri, 07 May 1999 19:29:07 -0500
Message-ID: <37338553.1F6C4440@deere.com>


Since a truncate statement is DDL, it commits immediately. Since it cannot be rolled back, nothing is entered into the rollback segment.

Paul Dudas wrote:

> I am unclear as to what actually exists in the rollback segments if I
> first truncate a table and then run a procedure to insert records into
> that same table. Thanks for your help..
Received on Fri May 07 1999 - 19:29:07 CDT

Original text of this message

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