ORA-1555 snapshot too old
From: Antonio Sant <asant_at_iol.it>
Date: Thu, 05 Oct 2000 22:59:11 GMT
Message-ID: <3J7D5.19638$NY2.548166_at_news.infostrada.it>
Date: Thu, 05 Oct 2000 22:59:11 GMT
Message-ID: <3J7D5.19638$NY2.548166_at_news.infostrada.it>
[Quoted] Hi there!
[Quoted] How can I resolve this problem?
[Quoted] 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!
[Quoted] 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 Fri Oct 06 2000 - 00:59:11 CEST