|
-
Ora-8103
Hi,
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 ?
Anybody has come across this kind of error ????
Can somebody help me out ?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|