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
ORA-08103: Object No Longer Exists
-
- Rank: Programador Júnior
- Posts: 19
- Joined: Mon, 22 Oct 2007 3:24 pm
- Location: SP
Grato.
Marcio Tavares
Marcio Tavares
-
- 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
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.
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.
- dr_gori
- 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
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 ...
I think she really does not exist anymore ...
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.
-
- Rank: Programador Júnior
- Posts: 19
- Joined: Mon, 22 Oct 2007 3:24 pm
- Location: SP
Grato.
Marcio Tavares
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:
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!
I confirmed with the other developers if there was any clause of type:
ON COMMIT DELETE ROWS;
ON COMMIT PRESERVE ROWS;
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!
-
- 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.
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.
-
- Information
-
Who is online
Users browsing this forum: No registered users and 1 guest