Re: oracle-l Digest V4 #181

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_at_ngc.com>
  >
  > 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
  >
  > ------------------------------
  

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