Home -> Mailing Lists -> Oracle-L -> ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table

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

From: Peter Teoh <htmldeveloper_at_gmail.com>
Date: Thu, 10 Apr 2008 13:56:51 +0800
Message-ID: <47FDAC23.5050407@gmail.com> 






I executed
the following query:



select rowid, table_name from dba_tables where table_name = 'r'

                              *

ERROR at line 1:

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





Check the internet but provide no reason, leads.   Neither does "oerr"
help - nothing mentioned for cause and action.








--
http://www.freelists.org/webpage/oracle-l
Received on Thu Apr 10 2008 - 00:56:51 CDT












Original text of this message