Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Tracing an ORA-01410 error
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-lReceived on Tue Sep 25 2007 - 08:31:51 CDT