Re: Oracle : ORA01410-invalid ROWID error

<jani.vivek_at_gmail.com> wrote in message news:1115628168.063721.59170_at_o13g2000cwo.googlegroups.com...
> Hi Jonathan,
>
> Thanks for your reply. Actually we are not sure of any index rebuilds
> happening on the database from which we are selecting since we have
> very limited access to it( We can't even select from the actual tables
> or view explain plans..We can just select from the specified views). I
> can tell you only one thing that the tables underlying the views which
> we are accessing are getting updated on a daily basis(from 01:00 to
> 07:00 hrs) while we run our cron twice a week(from 00:00).
>
> So, is it possible that the cron is failing due to the updation of the
> tables queried by the views or the views getting refreshed while they
> are still being queried?
>
> Regards,
> Vivek Jani
>

Two thoughts:
One

    If there is a big overnight update going on at the     other database, it is possible that the code there     does something clever with indexes to minimise     the update time - and a standard trick would be     to mark unusable and rebuild ... just ask the     people in control at the other end if they do     something like that.

Two

    In principle, you should not be able to get     ORA-01410 just because a table is being     updated wildly and you are accessing it     through a view.
    BUT - I don't know about distributed queries     and Oracle error handling. It is possible, I suppose     that some funny little bug exists that generates the     wrong error across a database link. PERHAPS     your query gets a 'snapshot too old' at the remote     database, but this is somehow turned into 'invalid     rowid' as it propagates through the system.     This is EXTREMELY unlikely, and only making     noises to point out that the problem could be     something that can only be tracked down on a     distributed system - but it is worth asking the     people at the other end to look for trace files     generated at about the time you get the 1410,     just in case they find something completely     different.

-- 
Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/seminar.html
Public Appearances - schedule updated April 5th 2005