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

Home -> Community -> Mailing Lists -> Oracle-L -> Tracing an ORA-01410 error

Tracing an ORA-01410 error

From: Schauss, Peter <peter.schauss_at_ngc.com>
Date: Tue, 25 Sep 2007 08:31:51 -0500
Message-ID: <CD9150D80CFCFB42BC73C40791C1E0197FBDC8@XMBIL112.northgrum.com>


I am still trying to track down the cause of an intermittent ORA-01410 error which some of our data warehouse reports are seeing. I have extracted the SQL from one of the reports and added "alter session set events '1410 trace name errorstack level 3'" to the script to force it to write a trace file when it gets the error hoping to be able to determine which of the 18 tables in query it is choking on. So far, I have not seen anything useful in the trace file.

Is there anything in the trace file I have which will tell me what table is giving me the ORA-01410 error?

Is there different trace level that I can invoke which will give me the information that I need?

This is Oracle 8.1.7.4 running on SUN-OS 5.9.

Thanks,
Peter Schauss

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Sep 25 2007 - 08:31:51 CDT

Original text of this message

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