Re: ORA-01445 Error description?

mkoren_at_trepang.mitre.org (Mark Korenkiewicz) wrote:
>
> 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

Hi, Mark.

You're trying to get some information that just doesn't make sense for a view. Here's why : ROWID is an internal "pseudo-column" available for a table. Its value is determined by the database when the row is created. A multi-table view is just shorthand for a query, which is evaluated when you access the view. Since a view is not a table, it does not have a ROWID. Your request for it just does not make sense to the database. As it happens, a single-table view behaves much like a table, including the ability to access the ROWID of the underlying table.

If this doesn't make sense, send me an email at thompsoc_at_groupwest.ca

Regards,
- Charles Thompson Received on Wed Apr 05 1995 - 00:00:00 CEST