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

Home -> Community -> Usenet -> c.d.o.misc -> ORA-08103 object no longer exists

ORA-08103 object no longer exists

From: Bard <bwskiles_at_adpc.purdue.edu>
Date: 1997/01/22
Message-ID: <01bc0886$cd05f1d0$f065d280@freh-nt-007>#1/1

On Monday, I upgraded from 7.3.2.1 to 7.3.2.2, and then applied the patch to 7.3.2.3. (We're running on HP-UX 10.20) Now, my users are getting the ORA-08103, "object no longer exists" error. All of their tables, indexes, etc... still exist, and I've verified this.

We've also discovered that if we play around with which field we set limits on, the query works fine. For example, we have a DEPT field in our TRANSACTION table and in our OBJECT_CODE table. If we limit on DEPT in TRANSACTION, we get the 08103. If we change the limit to the OBJECT_CODE table, the query executes with no difficulty.

Also, if we remove the limit on DEPT, the query works.

Also, if we change one of the limits on the OBJECT_CODE table so that no records match the criteria, the query works.

Other info: There are indexes on both DEPT columns. The I've rebuilt the index on the TRANSACTION table. I've reanalyzed the TRANSACTION table. All of these queries worked fine on Friday when we were still on 7.3.2.1.

Anyone have suggestions on where to look for the problem???

TIA. --Brad


Received on Wed Jan 22 1997 - 00:00:00 CST

Original text of this message

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