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
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