Re: Running out of rollback

In article <3k0775$20d_at_camelot.qdot.qld.gov.au> jb2_at_qdot.qld.gov.au (John Blackburn) writes:

>In my experience, deleting rows causes rollback activity for the simple
>reason that you might need to rollback your transaction thus 'undeleting'
>all your rows that you just deleted.
 

>We had a problem similar to yours on our system. We overcame the problem
>by having nested cursors that deleted a sufficiently small number of rows
>at a time so as not to blow out the roll back segment, and performing
>a commit between each group of rows deleted.
 

>I hope this helps,

This does but could you show an example. I'm not real big on SQL yet.

Rex Warren Received on Tue Mar 14 1995 - 11:08:40 CET