Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.oracle -> Re: Creating foreign keys across different tablespace

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@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 - 05:40:57 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US