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

  • From: Peter Teoh <htmldeveloper@xxxxxxxxx>
  • To: Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 10 Apr 2008 13:56:51 +0800

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.


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

Other related posts: