Re: inter references from one schema to another

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

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

 Yes.

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

 Yes, but don't you mean:

grant references ON schema2.tableB to schema1;

                 ^^              ^

 ('on' not 'to', tableB not tableA)

 By the way, what happened when you tried this on your copy of Oracle?

-- 
Andy Hassall / <andy@andyh.co.uk> / <http://www.andyh.co.uk>
<http://www.andyhsoftware.co.uk/space> Space: disk usage analysis tool