From oracle-l-bounce@freelists.org Thu Mar 11 02:42:03 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i2B8g2Z31710 for ; Thu, 11 Mar 2004 02:42:02 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i2B8g2o31705 for ; Thu, 11 Mar 2004 02:42:02 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E4933395004; Thu, 11 Mar 2004 03:41:33 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 11 Mar 2004 03:40:25 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from xenon.neuges.net (xenon.neuges.net [194.250.170.150]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0F5C7394E89 for ; Thu, 11 Mar 2004 03:40:22 -0500 (EST) Received: from somewhere.xenon by somewhere.xenon (8.9.3/8.9.3/1.1.3) with ESMTP id JAA18412 for ; Thu, 11 Mar 2004 09:47:47 +0100 (MET) Received: from somewhere.xenon by somewhere.xenon (8.9.3/8.9.3/1.1.3) with ESMTP id JAA18408 for ; Thu, 11 Mar 2004 09:47:46 +0100 (MET) Received: from somewhere.diderot by somewhere.diderot (8.9.3/8.9.3) with ESMTP id JAA13421 for ; Thu, 11 Mar 2004 09:49:09 +0100 (MET) Received: by ngmailroute.pc.ctlmcof.fr with Internet Mail Service (5.5.2657.72) id ; Thu, 11 Mar 2004 09:46:18 +0100 Message-ID: From: "NGUYEN Philippe (Cetelem)" To: "'oracle-l@freelists.org'" Subject: Strange snapshot too old during a select statement Date: Thu, 11 Mar 2004 09:46:17 +0100 Importance: high X-Priority: 1 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2657.72) Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C40745.51414BDD" X-archive-position: 447 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: philippe.nguyen@cetelem.fr Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l ------_=_NextPart_001_01C40745.51414BDD Content-Type: text/plain; charset="iso-8859-1" Hi list! we encounter a very strange "ORA-01555 : snapshot too old :rollback segment number 3 with name "_SYSSMU3$" too small" This is a very long query With a query that only make a select statement. We have open a TAR with Oracle Support but they say that it's not possible since this only a "select" statement ?!! Any idea ? TIA Philippe ------_=_NextPart_001_01C40745.51414BDD Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Strange snapshot too old during a select statement

Hi list!
we encounter a very strange "ORA-01555 : = snapshot too old :rollback segment number 3 with name = "_SYSSMU3$" too small"
This is a very long query
With a query that only make a select = statement.
We have open a TAR with Oracle Support but they say = that it's not possible since this only a "select" statement = ?!!
Any idea ?

TIA
Philippe

------_=_NextPart_001_01C40745.51414BDD-- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------