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 -> Re: commit afer unable to extend rollback segment

Re: commit afer unable to extend rollback segment

From: Dan Clamage <clamage_at_mime.dw.lucent.com>
Date: 1997/10/22
Message-ID: <01bcdec3$e46ba4a0$54110b87@clamagent>#1/1

I thought an Oracle error rolls back the last transaction. -djc

> Well, it all depends on how many SQL statements had run before COMMITing.
> If it is just one statement, OK, never mind. But if you have two or more
> statements before the COMMIT, then all data manipulations made by them
 will
> be written, except for the last statement (that one which caused the
> error). This situation may be not desirable, I don't know what is this
> "one-time thing".
Received on Wed Oct 22 1997 - 00:00:00 CDT

Original text of this message

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