Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-08103 Object no longer exists
Patrick Callahan wrote:
>
> John Struse wrote:
> >
> > Hi folks;
> > I am using Oracle 7.3.2.3.0 on an HP Unix platform. Just recently we
> > began to get the above error when doing some selects. We finally traced
> > it to the fact that we had added some indexes to the table in question.
> > We get the error when doing:
> > select * from products where prod_code = ;NJ12345' and status = 'A';
>
> John,
>
> I'm also working with 7.3.2.3 on a K460 running 10.20 and have been
> experiencing the same problem. I was passed some code that did something
> like
>
> update t1
> set t1.fk_id = (select t2.id from t2 where t2.cd = t1.cd and t2.clndr_da
> = t1.clndr_da)
> ...
>
> Code works find under 7.2 and WIN95 but fails on the HP. It would
> sometimes bomb
> right away and sometimes bomb after updating just some of the records.
> The problem
> would go away if the the dates comparisions were removed. Of course this
> didn't give
> the right result. We were able to code around the problem and haven't
> had time
> to investiage it further. Again we only saw the problem when comparing
> dates. I'm
> going to check the schema tomorrow to see if any indexes were involved.
> I'll
> post in this group if I find anything.
>
> Patrick Callahan
I heard through an email reply to my posting from a person who found a similar query in DejaNews by typing in "ORA-08193" and asking for old messages: What he sent me was:
If you are using Oracle V7.3.2.x, there is a bug. From Oracle you can get a patch for that bug, the bug number is 434788. This bug results on some ports of oracle in this ORA-8103 message.
--- Also when I called Oracle today, they referenced a bug number of 424581 and were going to send me a patch. So if it's not the one it should be the other. Thanks for the replies, and I hope this also helps you. John Struse (to reply please remove dash in email address)Received on Wed Oct 22 1997 - 00:00:00 CDT