Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Tracing invalid rowid ora-01410

Re: Tracing invalid rowid ora-01410

From: Rhojel Echano <rhojel.echano_at_gmail.com>
Date: Thu, 27 Jul 2006 23:54:33 +0800
Message-ID: <16e45e3f0607270854n44299584s8d3f099cdc73805f@mail.gmail.com>


it's $OH/rdbms/mesg/oraus.msg. No helpful info for that event though.

Cheers.
Rhojel

On 7/27/06, Schultz, Charles <sac_at_uillinois.edu> wrote:
>
> 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
>
>
>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US