ORA-08103: object no longer exists

pqrabc · Post by **pqrabc** » Wed May 23, 2012 4:26 am

Hi,

We have a server job where in the pre sql drops a table "X" and the SQL section creates the same table from a view.

While doing so the ETL fails with below error:
ORA-08103: object no longer exists

But the objects do exists in DB, still we are facing the issue.

Also few other jobs in the project fail while loading data into a target table while sourcing data from a bunch of tables.

Can someone help ?

chulett · Post by **chulett** » Wed May 23, 2012 7:00 am

I struggled with the same occassional error some time ago. The problem is many things can return a 'false' ORA-08103 as noted here and the behaviour is dependant on your version of Oracle. We never got a fix for it and a simple restart 'fixed' the problem.

If you want help with this:

"Also few other jobs in the project fail while loading data into a target table while sourcing data from a bunch of tables."

You'd need to explain what that means and detail the issues / errors you are seeing. And it really should be in another (separate) post.