Re: ORA-1555 snapshot too old

i think your DBA is right, the best way is to make short transactions ....it's more coding :-( ... but better performance :-)) ...

with kind regards

            St. Prietz

Antonio Sant wrote:

> 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 Fri Oct 06 2000 - 08:58:57 CEST