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.

Reply via email to