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

From: Ken Naim <kennaim_at_gmail.com>
Date: Thu, 10 Apr 2008 02:48:43 -0400
Message-ID: <CF1936E125724A25ABBED2005B9373D6@KenPC>

Dba_tables, is a view of several sys and x$ tables many of which don't have unique indexes/constraints.  

Ken  

---

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Peter Teoh
Sent: Thursday, April 10, 2008 1:57 AM
To: Oracle-L Freelists
Subject: ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table  

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

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

Received on Thu Apr 10 2008 - 01:48:43 CDT