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

Home -> Community -> Usenet -> c.d.o.server -> inter references from one schema to another

inter references from one schema to another

From: Rayan Yellina <rayan.yellina_at_gmail.com>
Date: 21 Sep 2004 13:09:08 -0700
Message-ID: <3b6586a.0409211209.6d391054@posting.google.com> 





Hi,


   I am a SQL SERVER guy (new to Oracle). This question might be
obvious for you guys. The question is....
 Is it possible to have a foreign key constraint
[schema1.tableA.field] referencing a [schema2.tableB.field] . I mean
it is referencing the table in another schema.
If yes, then is this below privillege sufficient
grant references to schema2.tableA to schema1;



Thank you,


-Rayan.
Received on Tue Sep 21 2004 - 15:09:08 CDT












Original text of this message













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