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

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

>

>