ORA-1555 snapshot too old

Hi there!

How can I resolve this problem?

After a talk with our DBA the suggestion was to translate this:

For tmp in (select ... ) Loop
 ....
 commit;
end loop;

in this

For tmp in (select ... ) loop
  temp_table(i):=tmp;
 i:=i+;
end loop;

For tmp in 0..temp_table.Count-1 loop

  ...
  commit;
end loop;

This is simple for a little script but it's awful to do with bigs ones!

Is there a way (i.e. an Oracle setting) that I can use?

I can't add more rollback segment!

I get this error in Oracle 7.4 and Oracle 8.

On the machine running Oracle 8 we have 4 rollback segment 1 G each!

Plase help! Received on Thu Oct 05 2000 - 17:59:11 CDT