| strange object no longer exists [message #60745] |
Tue, 02 March 2004 06:38  |
Kapil
Messages: 145
Registered: May 2002
|
Senior Member |
|
|
I am getting this starge problem in oracle.In log file we r geting that the
job was fail due to object V_TEMP_INVOICE was not found . In
reality it was found there . Why are we getting this problem any
idea...thoughts. If this table is temporary table ?????
Error Text: ORA-08103: object no longer exists
|
|
|
|
| Re: strange object no longer exists [message #60748 is a reply to message #60745] |
Tue, 02 March 2004 08:53  |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
08103, 00000, "object no longer exists"
// *Cause: the object has been deleted by another user since the operation
// began
// *Action:
If it still exists,make sure its still visible and accessible ( synonyms, privileges) to the user. Check ALL_TABLES. If these things are OK, do a ANALYZE VALIDATE STRUCTURE on this table to make sure the table itself is OK.
-Thiru
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
