If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Hybrid View

When I try to access a table in my database I get this message ORA-08103 object does not exist. But I can describe this table and future after gettin this problem I checked my alertlog and found that the there was an error for disk i/o for the disk being full, does this caused to corrupt my table , I had no other to go than restoring the previous days backup. I really dunno why I was not able to do anything with that table after the server disk got full!!!!!!!!!!!

Yes thats my doubt, I was able to use other tables as usual only this particular table kept on giving ORA-08103 error whenever I try to do any operations with it other than the describe command. Is it so that this table got corrupted due to disk i/o problem is there any way of bringing the table back????

So atleast I don't rely on desc.desc mainly contacts data dictionary info rather than accessing the object.

Now in your case the Data-dictionary info is intact
Some how the link between the object_info and object(in your case table) is broken...(may be due to I/O problem
you faced).Now what is the exact message in alert log

Thanks for ur dedicating the time and patience to reply my problem, but I cannot provide the info u had requested since I had replaced the database with the lastest dump and before doing this I backed up the database with was having this table problem after which I import this corrupted data in another machine to find that the corrupted table had no longer any rows and all operations were able to be done on it. I had no time to explore the possibilities of the problem cos it affected the live transactions!!!!!!!!!
Once again thanx all.