RE: init.ora parameter to log errors to the alert log

From: Allen, Brandon <Brandon.Allen_at_OneNeck.com>
Date: Wed, 30 Apr 2008 10:22:53 -0700
Message-ID: <04DDF147ED3A0D42B48A48A18D574C450B73A111@NT15.oneneck.corp>


Not sure if this is what you're thinking of, but you can set an event to create dump files in user_dump_dest when a certain errors is raised, e.g. the following would work for any ORA-0942 (table or view does not exist) errors:  

event="942 trace name errorstack level 3"

Regards,
Brandon  

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Apr 30 2008 - 12:22:53 CDT

Original text of this message