Re: ORA-01445 Error description?

mkoren_at_trepang.mitre.org (Mark Korenkiewicz) writes:

>I am getting the following error:
 

>ORA-01445: cannot select ROWID from view of more than one table
 

>I am trying to access a three table view. I have not been able to lay my hands
>on a description of what this error is trying to tell me. Could someone
>give me a hint as to what this means, or where I can find a description of
>what this error means. Any info is greatly appreciated, thanks.

> Mark Korenkiewicz
> The MITRE Corporation
> McLean, VA

If you are doing something like this:
select time, date, user, rowid
from a,b
where a.time = b.time

then Oracle won't know which rowid you want, the one from table A or the one from table B. Received on Sat Apr 08 1995 - 00:00:00 CEST