Re: ORA-1555 snapshot too old

Simple donot read from same table and commit to the same table... u r creating a very fine large rollback if u have to commit commit every 10000 lines and close and open cursor again

"Antonio Sant" <asant_at_iol.it> wrote in message news:3J7D5.19638$NY2.548166_at_news.infostrada.it...
> 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 Sat Oct 07 2000 - 06:32:34 CEST