Re: oracle-l Digest V4 #181

Hi Peter,

Looks like query you have is from Siebel Analytics. If you are using DAC to refresh data from Siebel to Siebel Analytics, it tends to drop and recreate indexes in order to speedup data load. Check DAC schedule. As always, Jonathan's diagnosis is very accurate...

Regards
Mindaugas Navickas
Oracle&DB2 DBA

• Original Message ---- From: Jonathan Lewis jonathan_at_jlcomp.demon.co.uk

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

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