Foreign Key Constraints over DB Links
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Foreign Key Constraints over DB Links

Hybrid View

  1. #1
    Join Date
    Feb 2000
    Location
    Alexandria, VA, 22314
    Posts
    41

    Talking

    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

  2. #2
    Join Date
    Jan 2001
    Location
    St. Louis. MO
    Posts
    150
    You cannot implement FK constraint over dblink. What you can do is to write a trigger mimicking the function of the FK constraint.

    Ed

  3. #3
    Join Date
    Feb 2000
    Location
    Alexandria, VA, 22314
    Posts
    41
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width