Re: commit every x rows (V6)

Oh I wish. Ran into same problem. Had to use PL/SQL. BTW, you can't use commit while processing a cursor that was defined as "FOR UPDATE OF column1, column2, ..."! Gives "fetch out of sequence err".

John Dennis

Steve Corbett (p0070623_at_oxford-brookes.ac.uk) wrote:
: I have some Sql that goes like...
 

: delete table_a;
 

: Space is a bit tight on out test system and i get the error
: 'failed to extend rollback segment'
 

: Besides writing it in Pl/Sql to build a loop with a commit every x
: transactions, are there any ways of getting oracle to do a periodic
: commit?
 

: --
: Steve Corbett. vvv
: [. .]
: p0070623_at_brookes.ac.uk --------o00-(_)-00o---------
Received on Wed Feb 09 1994 - 22:42:21 CET