Re: inter references from one schema to another

On 21 Sep 2004 13:09:08 -0700, rayan.yellina_at_gmail.com (Rayan Yellina) wrote:

>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.

yes
yes

--
Sybrand Bakker, Senior Oracle DBA