Thanks all. I was able to generate trace file with the following: SQL> alter system set events '1410 trace name errorstack level 3'; Deepak --- oracle-l-bounce@xxxxxxxxxxxxx wrote: > The message file is: > $ORACLE_HOME/rdbms/mesg/oraus.msg > I only mention it because I have been led to believe > that you can trace > any of those events/messages. > OBVIOUS WARNING: Be careful with some of those - > Oracle has stated that > you should only set them with direction from Oracle > Support > > > -----Original Message----- > From: Schultz, Charles > Sent: Thursday, July 27, 2006 10:16 AM > To: 'sharmakdeep_oracle@xxxxxxxxx'; > oracle-l@xxxxxxxxxxxxx > Subject: RE: Tracing invalid rowid ora-01410 > > I am thinking any of the errors can be traced with: > event="<nnn> trace name errorstack level <x>" > Not sure what the level would be for this error, but > you might be able > to start with 1. > > Now I just have to wait for someone to correct me if > I am wrong. =) I > know there is a mesg file in $OH that describes all > the events, but for > the life of me I cannot remember it. > > -----Original Message----- > From: oracle-l-bounce@xxxxxxxxxxxxx > [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of > Deepak Sharma > Sent: Thursday, July 27, 2006 9:58 AM > To: oracle-l@xxxxxxxxxxxxx > Subject: Tracing invalid rowid ora-01410 > > How do we force the generation of a trace file > whenever an error > (invalid rowid ora-01410) happens in the database. > Right now only some > of the ORA-01410 show up in alert log, but not all. > Is there a 'alter > system set event <nnn>' that can be done to achieve > this? > > Thanks, > Deepak > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- //www.freelists.org/webpage/oracle-l