ORA-08103: object no longer exists
532632Jun 27 2008 — edited Jul 4 2008Dear Experts,
I have a very tricky situation here.
A background job runs daily on our Production, which kinds of populates a lot of tables in another database (warehouse).
This morning, the job failed with an error: ORA-08103: object no longer exists
This error came while populating a table through a procedure.
I checked that the procedure and table both are in valid state and there are proper grants in place.
Also, we had faced the same problem few days back for the same table. We did not change anything. Simply re-ran the job and it went fine. Now also, we are re-running teh job and waiting to check if it goes fine.
Any ideaas why this error would come?
Thanks.