It is in the session trace file not the alert log file. Anjo.
On Wednesday 21 August 2002 16:38, you wrote: > Gogala > > Thanks for the tip this seems like just what I'm looking for, > however I must be doing something wrong as no errors are getting written > to my <SID>alrt.log > > Im running oracle 8.16 server on win2kpro (this is a development > database) > > I just got around to running/testing this from my post last week > > I do > SQL> alter session set events='0001 trace name errorstack forever, > level 10'; > > Session altered. > > Then I run the offending insert script which show errors being thrown > > I check the <SID>alrt.log in BDUMP dir and all it show are my regular > .ORA logs being written > EG > Wed Aug 21 09:19:07 2002 > Thread 1 advanced to log sequence 3240 > Current log# 4 seq# 3240 mem# 0: > D:\DB_TRACK2DATA\ORADATA\LTRACK2\LOG4LTRACK2.ORA > Thread 1 advanced to log sequence 3241 > Current log# 1 seq# 3241 mem# 0: > D:\DB_TRACK2DATA\ORADATA\LTRACK2\LOG1LTRACK2.ORA > Thread 1 advanced to log sequence 3242 > Current log# 2 seq# 3242 mem# 0: > D:\DB_TRACK2DATA\ORADATA\LTRACK2\LOG2LTRACK2.ORA > Thread 1 advanced to log sequence 3243 > > Also checked the <SID>alrt.log in Oracle\home\database > Nothing written there > > What am I missing? > > > alter session set events='0001 trace name errorstack > > forever, level 10'; All "duplicate value" errors will then be > > trapped in the alert.log file. You can always substitute your > > own favorite error in place of 0001. > > Also If you have a extra min how can I substitute the error message? > > Thanks for your help > > Bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anjo Kolk INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).