Re: Does anyone know how to trace a particular Oracle Error?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 11 Aug 1999 16:26:14 +0100
Message-ID: <934385697.3733.0.nnrp-04.9e984b29@news.demon.co.uk>

alter session set events '1407 trace name errorstack'; or
alter session set events '1407 trace name errorstack, level 12'; or you might find this most useful:

alter session set events '1407 trace name processstate';

In each case you get a line in the alert log, and a trace file dumped

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Luis Campos wrote in message <7orvs9$75j$1_at_duke.telepac.pt>...
>I need to generate a trace file each time my database is a target of a
>particular error. For instance: I want to trace ORA-1407, which is the
>attempt of updating to null a NOT NULL column. How can I do it for this
>particular error code?
>
>Thanks.
>
>Luis.
>
>Ps: You can email me at lcampos_at_kissmyassyouspamjerks.com by replacing the
>domain name for cpcis.pt
>
>
Received on Wed Aug 11 1999 - 10:26:14 CDT