| ORA-08103: object no longer exists [message #55890] |
Fri, 21 February 2003 16:55  |
Adam Carnine
Messages: 2
Registered: February 2003
|
Junior Member |
|
|
Hi all,
Please forgive me if I have the wrong forum, but here is my question:
I am using Oracle 8.0.5
I am getting the above error.
I have searched and the official reason is that the table has either been dropped or truncated during the operation. The odd thing is that (to the best of my knowledge) no such action has been taken.
Also I can reperform the query that throws this error and it fails at the same point.
I'm trying to find out if there is any recovery from this, and if so what that would be.
If anyone needs any further information to help please let me know.
|
|
|
|
|
|
| Re: ORA-08103: object no longer exists [message #55919 is a reply to message #55890] |
Mon, 24 February 2003 08:19  |
Adam Carnine
Messages: 2
Registered: February 2003
|
Junior Member |
|
|
Hi Raja,
I didn't use the double quotes during creation.
Upon rerunning the query with the table name double
quoted (and placed in the same case as when it was
created) I still get the same error at the same point.
This error isn't caused by the structure of my query,
but rather do to either a rogue external process (or
user) deleting the table OR due to a file error in the
disk drive on which the physical data files are stored
for this tablespace.
I'm fairly sure that it is not a rogue user or process
because if this were the case I'd expect the error to
not be reproducable. IE I'd see the error once and then
I'd see something like: ORA-00942: table or view does not exist
Any other suggestions are more than welcome, I still
can't physically inspect the drive myself, but I will
have someone doing that within 48 hours. If the drive
is fried then I'm not sure where to go, but I am fairly
sure of what will happen (as far as recovery).
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
