Home » RDBMS Server » Server Administration » strange object no longer exists
- strange object no longer exists [message #60745] Tue, 02 March 2004 06:38 Go to next message
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

Report message to a moderator

- Re: strange object no longer exists [message #60748 is a reply to message #60745] Tue, 02 March 2004 08:53 Go to previous message
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

Report message to a moderator

Previous Topic: creating tables in another schema
Next Topic: dblink creation problem
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 04 18:56:12 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.