SQL & PL/SQL

Hi,

I have the following error that appears intermittently during a scheduled run of a procedure.

"ORA-08103: object no longer exists"

If I re-run it, it runs just fine.

I investigated and noticed the point where procedure fails it is either:

- table truncate
- insert statement that uses views to insert values in another table

From my understanding regular tables can't become invalid and so the problem is the insert statement that pulls values from a view. The view somehow becomes invalid, the insert statement fails, but pushes the recompilation and so the next run works fine. However, this also means I can't identify who the culprit is for sure..

I looked at the INSERT statement (that inserts from a view and few other tables): the view pulls data from two tables. However, I noticed that last DDL dates on both tables are couple months old. I am puzzled... What could invalidate that view?

Any ideas?

Thanks!

Edited by: 789886 on Aug 20, 2010 3:12 PM

Edited by: 789886 on Aug 20, 2010 3:13 PM

Edited by: 789886 on Aug 20, 2010 3:13 PM

Edited by: 789886 on Aug 20, 2010 3:14 PM