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 -> Re: Foreign key on multiple base

Re: Foreign key on multiple base

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Fri, 19 Dec 2003 11:15:18 -0800
Message-ID: <1071861224.147571@yasure>


Laurent RUHLMANN wrote:
> Hi,
>
> Is it possible to create a foreign key that references a table in another
> database ?
>
>
> Thanks,
>
> Laurent

As in across a database link? What happens when the link is closed? I'd suggest you replicate the values.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Fri Dec 19 2003 - 13:15:18 CST

Original text of this message

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