Re: ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table
Date: Fri, 11 Apr 2008 08:02:50 +0100
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
If you can give the reason why you think you need it then perhaps someone can suggest a work around.