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.
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
|
