Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: database link & integrity
Yes !!!!
You must generate Database links from one database to another.
Then you must generate triggers on the table with the "FK" which checks the
data in the other database.
On the table with pk you must generate a trigger which delete the records on
the other database (on delete cascade).
Larry Pettit wrote:
> 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
--