Re: commit every x rows (V6)

Phil Huber (phil_at_mtu.edu) wrote:
: 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?
: :
: Try something like:
 

: delete from table_a where rownum < 1000;
: commit;
: delete from table_a where rownum < 1000;
: commit;
: delete from table_a where rownum < 1000;
: commit;
: etc until they're all gone

in other words build a pl/sql loop :(

--
Steve Corbett.                        vvv
                                     [. .]
p0070623_at_brookes.ac.uk    --------o00-(_)-00o---------