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


> 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