When i am selecting from a table, it gives the error
select * from emp;
ORA-8103-object no longer exists
Well, desc works fine. I analyzed the table with validate structure and it gives no errors.
If i export and import, it works fine. But Create table as select * from doesnt work.
The statsu of the object is valid in dba_objects.
There are so many table in my Database, and every other day i am getting this error in new tables. I cannot do the exp/imp for all the time for the tables which i get the error.
Is there any one time solution for this ?
Well i searched in metalink; some people have reported the error but i couldn't find a concrete solution for this ?
I have faced this error upon block corruption. I had to extract all rows from the table that I was able to and then I recreated the table. As far as I remebr there were only 1-2 corrupted blocks invloved.
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g