Re: Creating foreign keys across different tablespace
From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Fri, 5 Mar 2004 06:40:57 -0500
Message-ID: <xZGdnb_hD7DW-tXdRVn-uA_at_comcast.com>
| As above.
| The error I got is "ORA-00942: table or view does not exist". Any ideas?
| TIA.
it's not a tablespace issue, the owner of the foreign key must have REFERENCES privileges granted on the PK table -- directly, and not via a role
Date: Fri, 5 Mar 2004 06:40:57 -0500
Message-ID: <xZGdnb_hD7DW-tXdRVn-uA_at_comcast.com>
"ahk" <ahk_at_writeme.com> wrote in message
news:eb02dbae.0403042356.70ae910d_at_posting.google.com...
| Hi,
|
| As above.
| The error I got is "ORA-00942: table or view does not exist". Any ideas?
| TIA.
it's not a tablespace issue, the owner of the foreign key must have REFERENCES privileges granted on the PK table -- directly, and not via a role
check the USER_TAB_PRIVS_RECD view
;-{ mcs Received on Fri Mar 05 2004 - 12:40:57 CET