Ora:1555: Snapshot too old (Rollback-Segment too small)

From: Frank Braun <f.braun_at_bigfoot.com>
Date: Sun, 10 Jan 1999 23:36:37 +0100
Message-ID: <77dg7a$b6h$1@hades.rz.uni-sb.de>

Hi.

I have a problem of principial nature:
I want to update more data sets than the Rollback-Segment can get. So I make a commit after each update-command. So I use following mechanism:

open curs;
loop

   fetch curs into v_rowid;
   exit when curs%NotFound;
   update tab

        set col
        where rowid = v_rowid;

  commit;
end loop;

Nevertheless I get sometime an error: Ora1555: Snapshot too old (Rollback-Segment too small):
Is there a principial method to avoid this error beside resizing rollback-segments?

Thank you,

greetings Frank. Received on Sun Jan 10 1999 - 16:36:37 CST