Re: ORA-08103: object no longer exists

I got this exact error as soon as I upgraded from 7.2 to 7.3. It is triggered by indexed searches that return one or more rows, which is why you don't get it on a select (*). The base bug # is 424581. Oracle already has a patch for it. Not sure what version of Oracle you are running, and I'm not sure when this bug was introduced. But it's really sounds identical to my problem of a few months ago.

Ed

Andrea wrote:
>
> Hi, sorry in advance for my bad engliI have a strange problem.
>
> If I try to make this sample statement:
> select count(*) from visite where data = '10-jun-96' and id_utente =
> '000255';
> i take always the error in subject.
> But if the statement is only select count(*) from visite where data =
> '10-jun-96' or
> select count(*) from visite where id_utente = '000255' all was ok.
>
> I don't know why.
>
> Thanks in advance.
>
> Andrea Savino
> A.Savino_at_agora.stm.it
 

-- 
~~~~~~~~~~~~~~~~~~~~~~~~~
jenningse_at_mindspring.com