Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Foreign Key question
You can do this provided you have the appropriate privileges - you'll need REFERENCEs privilege on the object.
Sean <dolans_at_my-deja.com> wrote in message
news:8s4lis$irb$1_at_nnrp1.deja.com...
> I would like to create a FK between two tables that belong to different
> owners: [This resides on an Oracle 8i, one instance, 2 schemas foo and
> bar)
>
> TableA (owner and schema foo)
> ---------
> foo_id (PK)
> username (FK)
> comments
>
> TableB (owner and schema bar)
> ---------
> username (PK)
> firstName
>
> So if I do a :
> ALTER TABLE "FOO"."TABLEA" ADD( FOREIGN KEY (USERNAME)
> REFERENCES "BAR"."TABLEB"(USERNAME));
>
> I get a ORA-00942 : table or view does not exist.
>
> Is this possible to reference a Foreign Key from another owner?
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Oct 12 2000 - 12:23:56 CDT