RE: Tracing an ORA-01410 error

This is a data warehouse application which I inherited. They run an ETL every hour and the ETL takes about 70 minutes (don't ask). Then they run reports while the ETL is running. Some of the reports are failing intermittently with ORA-01410. I need something to prove conclusively that the problem either is or is not related to the fact that the ETL is truncating tables and dropping and recreating indexes.

Interestingly, the errors only occur when the report is scheduled automatically. When it is manually immediately after a failure we don't get the error.

Thanks,
Peter Schauss

-----Original Message-----

From: Josh Collier [mailto:Josh.Collier_at_banfield.net] Sent: Thursday, February 05, 2009 7:03 PM To: Schauss, R. Peter (IT); oracle-l_at_freelists.org Subject: RE: Tracing an ORA-01410 error

what are you doing to generate the error? plain selects? I have seen this error involved with indexes. rebuilding the indexes fixed it.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Schauss, R. Peter (IT)
Sent: Thursday, February 05, 2009 1:12 PM To: oracle-l_at_freelists.org
Subject: Tracing an ORA-01410 error

Oracle 8.1.7.4/ Solaris 9

Some of our user reports are failing with ORA-1401- invalid rowid errors. Searching the archives I found a suggestion that I turn on tracing for this error with the command:

alter session set events '1440 trace name errorstack forever, level 3';

What kind of information can I expect to get from this trace?

Thanks,
Peter Schauss
--

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

--

http://www.freelists.org/webpage/oracle-l Received on Fri Feb 06 2009 - 08:04:18 CST