Re: ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table

From: Neil Overend <>
Date: Fri, 11 Apr 2008 08:02:50 +0100
Message-ID: <>

dba_tables is a SYS owned view, in my 10.2 instance it is

select .....
from sys.obj$ o, sys.view$ v, sys.user$ u, sys.typed_view$ t
where .....

rowid is the location of a single row in a table, in this case there is no single rowid that could be returned from dba_tables. It doesn't make sense to select rowid from a non key-preserved view.

And what do you need rowid for anyway, obviously you're not going to update dba_tables.
If you can give the reason why you think you need it then perhaps someone can suggest a work around.

Received on Fri Apr 11 2008 - 02:02:50 CDT

Original text of this message