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

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.

--
http://www.freelists.org/webpage/oracle-l