Referential Integrity
From: Wachs Rene <Rene.Wachs_at_ezv.admin.ch>
Date: 1996/04/12
Message-ID: <1996Apr12.085708.958_at_gw2.admin.ch>#1/1
Date: 1996/04/12
Message-ID: <1996Apr12.085708.958_at_gw2.admin.ch>#1/1
Hello
How to enforce referential integrity between 2 tables located in separate
Data-
bases ? Example :
table EMP is on DB A
table DEPT is on DB B
When I insert or update an employee the DEPTNO-Check against the DEPT-Table must be executed. How can I reach that ? Ref.-Int. doesn't work over DB-Links. Is the only solution a procedure or a DB-Trigger ?
Thanks for ANY ADVICE.
R. Wachs Received on Fri Apr 12 1996 - 00:00:00 CEST