Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-08103: object no longer exists

532632Jun 27 2008 — edited Jul 4 2008
Dear 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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 1 2008
Added on Jun 27 2008
16 comments
32,838 views