Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-8103

Re: ORA-8103

From: Cathy <remove_c.gulbrandsen_at_altimax.co.uk>
Date: Mon, 11 Oct 1999 08:51:32 GMT
Message-ID: <oyhM3.10103$18.336368@nnrp3.clara.net>


Thank you John,

I think I am going to take each step of the code apart and find out which one failes, I haven't done that yet.

There is only the one person attempting to run the report and they can run other reports with no problem.

Cathy,

TurkBear wrote in message <37fe5492.12336098_at_super.news-ituk.to>...
>Hi,
>
>Unless the report explicitly references an index, the missing object
probably is
>not one...It could be a synonym that got dropped, of a view that failed to
>compile for some reason - review the code in the report and find the object
>being referenced...Is more than one user running reports against the same
data ?
>There could be an intermediate step in the report that creates and then
deletes
>some temp object and, if the timing is bad, and the designation of the
object is
>ambiguous or just poorly specified, one user could start the report, get
to the
>creation step and move on to where its is deleted, just as the other user
needs
>it...
>
>Just a few of the interesting possibilities....
>
>
>
>"Cathy" <remove_c.gulbrandsen_at_altimax.co.uk> wrote:
>
>>Thank you,
>>
>>My developer is now the only one who doesn't agree with this. Can you tell
>>me if this object could be indexes as well as tables or columns?
>>
>>Cathy
>>Brian Peasland wrote in message <37FCC3A0.F10A4991_at_edcmail.cr.usgs.gov>...
>>>Check the message:
>>>
>>>ORA-08103: object no longer exists
>>>
>>> Cause: The object has been deleted by another user since the operation
>>>began.
>>>
>>>Action: Remove references to the object.
>>>
>>>It appears that someone has deleted the object that the report refers
>>>to. Recreate the object.
>>>
>>>HTH,
>>>Brian
>>>
>>>Cathy wrote:
>>>>
>>>> I have got a client who is on Oracle 7 and get this messge when running
a
>>>> report that has worked perfectly fine before.
>>>>
>>>> When they the same query in SQL + they still get the same error.
>>>>
>>>> ANy help or guidence woudl be appriciated.
>>>>
>>>> Thank,
>>>>
>>>> Cathy
>>
>
>
>
> -----------== Posted via Newsfeeds.Com, Uncensored Usenet News
==----------
> http://www.newsfeeds.com The Largest Usenet Servers in the World!
>------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers
==----- Received on Mon Oct 11 1999 - 03:51:32 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US