ora err 1555

Hello,

I'm running a C program with embedded SQL that is constantly bombing out with the error message ora-1555, refering that the 'snapshot is too old, rollback segment too small'. The manual says to use a larger rollback segment. Is this all I can do? And if I do get a larger segment from my dba, how do I specify to use it. The manual says to use the SET TRANSACTION statement, but where do I put this statement. If I put it at the begining of my procedure with my SQL calls, will this directive be valid for all the following SQL statements. Any advice would be much appreciated.

Thanks,
-rleffin Received on Wed Sep 20 2000 - 00:00:00 CDT