Re: transaction question

From: Jonathan Lewis <ora_mail_at_jlcomp.demon.co.uk>
Date: 1996/09/13
Message-ID: <3239A1E4.6A4D_at_jlcomp.demon.co.uk>#1/1


Here's an example:

SQL> update temp set remoteowner = 'x' where rownum < 200;

199 rows updated.

SQL> delete from temp;
delete from temp

            *
ERROR at line 1:
ORA-01562: failed to extend rollback segment (id = 1) ORA-01628: max # extents (2) reached for rollback segment JUNK

SQL> select remoteowner,count(*) from temp group by remoteowner;

REMOTEOWNER                      COUNT(*)

------------------------------ ----------
x 199

It seems that tThe rollback is only of the last SQL statement, just as with any other oracle error.

---

Jonathan Lewis
ora_mail_at_jlcomp.demon.co.uk Received on Fri Sep 13 1996 - 00:00:00 CEST

Original text of this message