Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: object no longer exists!!!!
Does anyone else have rights to that table? The error code indicates a deletion by another user:
Cause:The object has been deleted by another user since the operation began.
Action:Remove references to the object.
Stephen Bell <stephen.bell_at_cgi.ca> wrote:
>Hi Pinto,
>I was referring to your running out of space at 4 GB...as for bringing back
>the data....that's a different issue...this is a problem I haven't
>encountered but it may well be your data is still there...there are several
>folks with incredible experience that contribute to this group..hopefully
>they can offer us some wisdom..
>
>I wish I could fully answer your question Pinto...
>Steve
>
>Pinto wrote:
>
>> hello steve,
>> will adding datafile to the tablespace bring back all the data.????
>> regards,
>> pinto.
>>
>> Pinto <reach_me_at_india.com> wrote in message
>> news:9gcbfd$t15$1_at_news.mch.sbs.de...
>> > Hello all,
>> > i am facing a very strange problem.
>> > when i do a select from any table i am getting this error message,
>> >
>> > SQLWKS> select * from eb_bcp_job_user
>> > JOB_INT_ID USER_ID
>> > ---------------------------------------- ------------------------------
>> > ORA-08103: object no longer exists
>> >
>> > but select * from tab, lists all the table. what do you think has gone
>> > wrong.
>> > basically i was running a database intensive procedure, which contantly
>> > updates a log table and while the procedure was running, i just queried
the
>> > log table and this happened.
>> >
>> > any help greatly appreciated,
>> > many thanks in advance.
>> > Pinto.
>> >
>> >
>> >
>> >
>> >
>> >
-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =----- Received on Fri Jun 15 2001 - 10:02:10 CDT