This is not a DBD::Oracle issue. FSee metalink note # 45895.1
-
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Rob Benton [mailto:[EMAIL PROTECTED]
Sent: Friday, September 24, 2004 3:16 PM
To: [EMAIL PROTECTED]
Subject: Error on large select statement
-Original Message-
> From: Rob Benton [mailto:[EMAIL PROTECTED]
> Sent: 24 September 2004 22:16
> To: [EMAIL PROTECTED]
> Subject: Error on large select statement
>
> Got DBI version 1.3.5 (not sure which version DBD::Oracle.
> Is there a
> way to tell?) on RedHat AS
On Fri, Sep 24, 2004 at 05:27:01PM -0400, David N Murray wrote:
> For version info print $DBI::Version and $DBD::Oracle::VERSION.
>
> $ oerr ora 1555
> 01555, 0, "snapshot too old: rollback segment number %s with name \"%s\" too
> small"
> // *Cause: rollback records needed by a reader for co
ll <[EMAIL PROTECTED]> / Space: disk usage analysis tool
<http://www.andyh.co.uk> / <http://www.andyhsoftware.co.uk/space>
> -Original Message-
> From: David N Murray [mailto:[EMAIL PROTECTED]
> Sent: 24 September 2004 22:27
> To: Rob Benton
> Cc: [
For version info print $DBI::Version and $DBD::Oracle::VERSION.
$ oerr ora 1555
01555, 0, "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 lar
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.
PrintErr