Re: commit every x rows (V6)

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

Good luck,
Phil

-- 
  +---------------------------------------------------------------------+
  |  Phillip Huber   Analyst/Programmer   Michigan Technological Univ.  |
  |  Internet: phil_at_mtu.edu    Phone: 906-487-2223    Fax: 906-487-2787 |
  +---------------------------------------------------------------------+