From: "Sybrand Bakker" Newsgroups: comp.databases.oracle.server Subject: Re: Rollback segment too old Date: Wed, 6 Jun 2001 17:42:19 +0200 Message-ID: References: <9fka71$ies$1@news.netmar.com> X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4522.1200 X-MIMEOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 X-Complaints-To: abuse@nl.demon.net NNTP-Posting-Host: sybrandb.demon.nl X-NNTP-Posting-Host: sybrandb.demon.nl:212.238.21.78 X-Trace: beta-news.demon.nl 991842010 beta-news:30230 NO-IDENT sybrandb.demon.nl:212.238.21.78 Lines: 28 wrote in message news:9fka71$ies$1@news.netmar.com... > Is this error logged anywhere at the instance level. I was hoping to see it > in the alert logs or the trace files. I have a long running sql job which > failed but have no log of the failure. I suspect rollback segment too old > and was hoping Oracle tracked this one. Thanks in anticipation. > > > ----- Posted via NewsOne.Net: Free (anonymous) Usenet News via the eb ----- > http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups > NewsOne.Net prohibits users from posting spam. If this or other posts > made through NewsOne.Net violate posting guidelines, email abuse@newsone.net This error is an application error and thus *NOT* logged at the instance level. If your code has proper exception handling (and it probably doesn't) you can trap this error quite easily. Hth, Sybrand Bakker, Oracle DBA