RE: Tracing invalid rowid ora-01410

From: Schultz, Charles <sac_at_uillinois.edu>
Date: Thu, 27 Jul 2006 10:16:19 -0500
Message-ID: <565F609E6D736D439837F1A1A797F3419D1125@ADMINMAIL1.ui.uillinois.edu>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Deepak Sharma Sent: Thursday, July 27, 2006 9:58 AM
To: oracle-l_at_freelists.org
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
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Thu Jul 27 2006 - 10:16:19 CDT