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 -> database link & integrity

database link & integrity

From: Larry Pettit <larry.pettit_at_ps.net>
Date: Thu, 20 Jan 2000 10:46:45 -0700
Message-ID: <lIHh4.126$vg2.4169@news.uswest.net>


Is there a way to enforce referential integrity across databases with a database link. I tried it and it didn't work.

I have database1.tableA and database2.tableB. TableB is the parent in another database and I would like to make a column in tableA a FK to the PK of TableB.

Is it possible?

Thanks Received on Thu Jan 20 2000 - 11:46:45 CST

Original text of this message

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