Re: Rollback segment too old

<peter.mckenzie_at_health.wa.gov.au> wrote in message news:9fka71$ies$1_at_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_at_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 Received on Wed Jun 06 2001 - 10:42:19 CDT