ORA-08103 Object no longer exists

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?

SELECT *
  FROM TABLE1 t1,

       TABLE2 t2,
       TABLE3 t3
  WHERE t1.key = t2.key AND
        t1.key = t3.foreign_key AND
        t3.status_flag <> 'Y';              -- notice the "<>" sign

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.

Thanks
Brian Received on Fri Jun 06 1997 - 00:00:00 CDT