ORA-08103: Object No Longer Exists

Dúvidas, dicas e truques de PL/SQL. Aqui também vão assuntos relacionados a pacotes, triggers, funções, Java-Stored Procedures, etc
Post Reply
Marcio Tavares
Rank: Programador Júnior
Rank: Programador Júnior
Posts: 19
Joined: Mon, 22 Oct 2007 3:24 pm
Location: SP
Grato.

Marcio Tavares

Hello friends!

I am doing a select in a table (SQLPLUS and TOAD), and I am receiving the following error:

ORA-08103: Object No Longer Exists

But the table exists and I can see her script for Toad, I made the following play the table with the same script and passed normal.

Someone already passed this error or have any idea how can I do to access the data of this table?

Thanks!


: -O
Trevisolli
Moderador
Moderador
Posts: 2016
Joined: Wed, 12 Jan 2005 3:25 pm
Location: Araraquara - SP
Abraço,

Trevisolli
OCA Oracle PL/SQL Developer Certified Associate
OCP Oracle Forms Developer Certified Professional
Araraquara-SP

Brother,

Try to take a look if it is not permission on this table.
No "synonym" was removed?
This user who is using is the "Owner" of this Tablea?
Anything, send us to us.
User avatar
dr_gori
Moderador
Moderador
Posts: 5026
Joined: Mon, 03 May 2004 3:08 pm
Location: Portland, OR USA
Contact:
Thomas F. G

Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered

Strange ... according to the error, it seems that an incomplete recovery was made of this table ...

Select all

ORA-08103:  object no longer exists 
Cause:      The object has been deleted by another user since the operation began, or a prior incomplete recovery restored the database to a point in time during the deletion of the object. 
Action:     Delete the object if this is the result of an incomplete recovery. 
Action:     The options to resolve this Oracle error are: 
   1. Re-create the object. 
   2. Remove your reference to the object. 
 
 
I think she really does not exist anymore ...
Marcio Tavares
Rank: Programador Júnior
Rank: Programador Júnior
Posts: 19
Joined: Mon, 22 Oct 2007 3:24 pm
Location: SP
Grato.

Marcio Tavares

Then my friends, the user is the owner of the table. And the table was not deleted.

I confirmed with the other developers if there was any clause of type:

Select all

ON COMMIT DELETE ROWS; 
ON COMMIT PRESERVE ROWS;
But nothing!

by verifying that the space destined the table is still being used but so far, I have no success in recovering the data.

Thanks to all!
User avatar
dr_gori
Moderador
Moderador
Posts: 5026
Joined: Mon, 03 May 2004 3:08 pm
Location: Portland, OR USA
Contact:
Thomas F. G

Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered

If you find out something, it puts the solution to us :-
alcardimjr
Rank: Estagiário Júnior
Rank: Estagiário Júnior
Posts: 1
Joined: Sun, 28 Feb 2010 7:56 pm
Location: NOVA IGUAÇU- RJ
Augusto

I was with the same problem now, I had a procedure that realized inserts and updates and returned a cursor.

The problem is as follows. The table is in Lock.
In my case I had a Temp Table identifies in two distinct locations
to be able to take the test. One was with preserv rows and the other was with delete rows.
What was with preserv to function normal
the one with delete gave this error.
I put Tab Temp with Preserv Rows and it worked normally.
I hope I have helped.
Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 1 guest