RE: Tracing an ORA-01410 error
- From: "Schauss, R. Peter (IT)" <peter.schauss@xxxxxxx>
- To: "Josh Collier" <Josh.Collier@xxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 6 Feb 2009 08:04:18 -0600
Josh,
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@xxxxxxxxxxxx]
Sent: Thursday, February 05, 2009 7:03 PM
To: Schauss, R. Peter (IT); oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Schauss, R. Peter
(IT)
Sent: Thursday, February 05, 2009 1:12 PM
To: oracle-l@xxxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
