Re: oracle-l Digest V4 #181
- From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Sat, 30 Jun 2007 08:54:02 +0100
Do you have processes that could have rebuilt some
indexes - including the one used in this query - while
the query was running ? This could cause completely
random occurrences of Oracle error 1410, see:
http://www.jlcomp.demon.co.uk/circular.html
Regards
Jonathan Lewis
http://jonathanlewis.wordpress.com
Author: Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html
The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
----- Original Message -----
Subject: ORA-01410 - invalid rowid
Date: Fri, 29 Jun 2007 10:27:05 -0400
From: "Schauss, Peter" <peter.schauss@xxxxxxx>
I have a query which intermittently returns the following error:
@all_resolved_calls
siebel.W_ENTLMNT_D T7967,
*
ERROR at line 153:
ORA-01410: invalid ROWID
My first suspicion was that I had a corrupted index.
When I ran "analyze table .. validate structure cascade" to verify that
all entries in the table's indexes point to valid rowids I got no
errors.
My environment is Oracle 8.1.7.4 running on SunOS 5.9.
Where else should I be looking, or should I just blindly rebuild all
four indexes on the table.
Thanks,
Peter Schauss
------------------------------
--
//www.freelists.org/webpage/oracle-l
Other related posts:
