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

From: William Robertson <william_at_williamrobertson.net>
Date: Fri, 11 Apr 2008 07:36:24 +0100
Message-ID: <47FF06E8.6030809@williamrobertson.net>

No leads? Googling for "key-preserved table" gave several. Key-preserved tables are documented here (10.2):
http://download.oracle.com/docs/cd/B28359_01/server.111/b28310/views001.htm#ADMIN11783

-----Original message-----
From: Peter Teoh
Date: 10/4/08 06:56

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 Fri Apr 11 2008 - 01:36:24 CDT