Re: Oracle : ORA01410-invalid ROWID error

From: <jani.vivek_at_gmail.com>
Date: 9 May 2005 01:42:48 -0700
Message-ID: <1115628168.063721.59170@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 Received on Mon May 09 2005 - 03:42:48 CDT