Error on large select statement

From: Rob Benton (rob.benton_at_conwaycorp.net)
Date: 09/24/04 

Date: Fri, 24 Sep 2004 16:15:36 -0500
To:  dbi-users@perl.org

Got DBI version 1.3.5 (not sure which version DBD::Oracle. Is there a
way to tell?) on RedHat AS 2.1.

I need some advice. I'm doing an oracle query on a table that has over
23 million records and I keep running into this error near the end. I'm
not doing any updates, only a select.

PrintError, RaiseError are on and AutoCommit is off.

DBD::Oracle::st fetchrow_array failed: ORA-01555: snapshot too old:
rollback segment number 19 with name "_SYSSMU19$" too small (DBD ERROR:
OCIStmtFetch) at ./group_bb.pl line 144.