Re: ORA-08103 Object no longer exists

Cecil D'Souza wrote:
>
> Brian Gastineau <bgastine_at_giveblood.org> wrote in article
> <01bc72b6$f47d54c0$b90110ac_at_gastineau1.giveblood.org>...
> > Any idea why this works
> >
> > SELECT *
> > FROM TABLE1 t1,
> > TABLE2 t2,
> > TABLE3 t3
> > WHERE t1.key = t2.key AND
> > t1.key = t3.foreign_key AND
> > t3.status_flag = 'N'; -- notice the "=" sign
> >
> > but this returns the expected records plus a "ORA-08103 Object no longer
> > exists" error?
> > TABLE1 and TABLE2 have a one to one relationship. TABLE 1 and TABLE3
 also
> > have a one to one relationship. If I simplify the query to just two of
 the
> > tables, the problem does not occur for either where clause.
>
> Oracle Product Document Library (C) Oracle Corporation
> Manual: ORACLE 7.3 SERVER CODES Reference: A14538-16
>
> 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.
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.

Bye Chris Received on Mon Jun 16 1997 - 00:00:00 CDT