Skip to Main Content

Oracle Database Discussions

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!

SQL Error: ORA-08103: object no longer exists

deltanovJul 15 2011 — edited Jun 24 2013
Dear all,

The DB that I am working with is 10g.

After executing this :
 
select count(*) 
from table_1 
I got this:
 
Error starting at line 1 in command: 
select count(*) 
from cons_relationship 
Error report: 
SQL Error: ORA-08103: object no longer exists 
08103. 00000 -  "object no longer exists" 
*Cause:    The object has been deleted by another user since the operation 
           began, or a prior incomplete recovery restored the database to 
           a point in time during the deletion of the object. 
*Action:   Delete the object if this is the result of an incomplete 
           recovery. 
Any idea what can be the cause? How can I see if I have other objects in the DB that are corrupted?

Thanks a lot in advance for the help!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 22 2013
Added on Jul 15 2011
8 comments
4,853 views