-
Hi All,
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!!!!!!!!!!!
Regards,
Sudhakar
-
If disk I/O is the cause then you would not be able to access other objects as well.Even i faced the same problem.
But i was not even able to do even describe command.
regards
anandkl
-
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????
Rgds,
Sudhakar
-
You can do it using logminer...but i not sure how to do it.
regards
anandkl
-
Hi,
DESC command of sqlplus works very differently from sql
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
Paste it to me please
GOOD LUCK
-
This is the message in the alert log after which I get this error ORA-08103 whenever I tried to access a particular table,
Mon Sep 30 12:10:13 2002
Thread 1 advanced to log sequence 292
Current log# 2 seq# 292 mem# 0: E:\ORANT\DATABASE\LOGWMS2.ORA
Mon Sep 30 17:38:02 2002
Errors in file E:\orant\rdbms80\trace\ORA00302.TRC:
ORA-19502: write error on file "E:\ORANT\DATABASE\USR1WMS.ORA", blockno 1010522 (blocksize=4096)
ORA-27072: skgfdisp: I/O error
OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 112) There is not enough space on the disk.
Mon Sep 30 18:14:45 2002
Errors in file E:\orant\rdbms80\trace\ORA00279.TRC:
ORA-19502: write error on file "E:\ORANT\DATABASE\USR1WMS.ORA", blockno 1010522 (blocksize=4096)
ORA-27072: skgfdisp: I/O error
OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 112) There is not enough space on the disk.
Rgds,
Sudhakar
-
So, now, whats the status??
-
First check you are accessing the right object.IF you are sure about that
Now you contact Data dictionary info
connect as sys
select block_id from dba_extents where segment_name= and block_id=
The result of this query you inform us.
Cheers
-
I think the meta characters are lessthan sign is not allowed
for this forum
segment_name=your table_name
block_id=block-id shown in trace-file
if 0 rows are returned then run the query
select segment_name from dba_extents where block-id=1010522
In any case please let us know
GOOD LUCK
-
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.
Rgds,
Sudhakar