ORA-01555 snapshot too old ...

  I'm receiving this error and I can't really figure out why. The ORACLE Messages and Codes manual simply says to increase rollback space. I really don't think this is the problem (although it may solve it in the interim).

  My application is reading a number of rows (50,000) from a single table and creating new records in other tables and updating the read record. I've allocated what I consider more than adequate rollback space for this, yet I still get this error. In addition, this application is running in it's own instance and no other users are connected while it is running. Thanks in advance for any advice.

Tim Dry
tdry_at_sierra.net Received on Mon Sep 18 1995 - 00:00:00 CEST