FreeLists / oracle-l / Re: oracle-l Digest V4 #181

[Mindaugas Navickas <mnavickas@xxxxxxxxx>]

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@xxxxxxxxxxxxxxxxxx


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