Foreign Key Constraints over DB Links

Hi all,

Is it possible to enforce FK Constraints over a DB Link - I am going to create a synonym FACILITY which actually points to FACILITY@DATABASE2

Can I implement a FK to this table synonym?? If so, what happens if FACILITY@DATABASE2 deletes one of the rows, and DATABASE1 has an FK to it?

Thanks in advance...

Keith

You cannot implement FK constraint over dblink. What you can do is to write a trigger mimicking the function of the FK constraint.

Ed

This is what i was thinking from the very beginning. The trigger might be tricky on the other database, as it is being developed by another company, but this is my problem - not yours :)

thanks for the answer

-keith