Re: ORA-8103

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 Fri Oct 08 1999 - 15:37:22 CDT