| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Tracing invalid rowid ora-01410
Thanks all.
I was able to generate trace file with the following:
SQL> alter system set events '1410 trace name errorstack level 3';
Deepak
> 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_at_yahoo.com';
> oracle-l_at_freelists.org
> 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_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
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jul 27 2006 - 11:24:56 CDT
 |
 |