For version info print $DBI::Version and $DBD::Oracle::VERSION.
$ oerr ora 1555
01555, 00000, "snapshot too old: rollback segment number %s with name \"%s\" too small"
// *Cause: rollback records needed by a reader for consistent read are
// overwritten by other writers
// *Action: Use larger rollback segments
$dbh->do("set transaction use rollback segment a_really_big_segment");
$select->execute();
HTH,
Dave
On Sep 24, Rob Benton scribed:
> 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.
>
