Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ORA-1555 snapshot too old

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@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 Thu Oct 05 2000 - 17:59:11 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US