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

  • From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
  • To: <oracledba.williams@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 30 Apr 2008 10:22:53 -0700

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
 

Other related posts: