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!