Re: Distributed Constraints Oracle 8.0.5

From: Dante <dnotari_at_my-dejanews.com>
Date: Wed, 12 May 1999 23:10:32 GMT
Message-ID: <7hd1os$1f2$1@nnrp1.deja.com>

Yes there is,
you can use a trigger on the child to verify (using SELECT) from the master upon insert and update.

on the master you would have to check (in a trigger again) to the childs for integrity upon delete

of course the SELECTs via a DB Link

Regards
Dante

In article <7hcov1$oko$1_at_nnrp1.deja.com>, kpick_at_my-dejanews.com wrote:
> Does anyone have advice on how to solve the following problem I
> encountered during the design phase of OLTP distributed databases:
>
> I have multiple master tables which must allow read/write access from
> multiple distributed databases.
> The main obstacle is the distributed databases need to perform
> referential integrity checks against the master tables. I am told
> Oracle does not allow creation of foreign keys referencing remote
> tables.
>
> Are there any valid options other than replication?
>
> --== Sent via Deja.com http://www.deja.com/ ==--
> ---Share what you know. Learn what you don't.---
>

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Wed May 12 1999 - 18:10:32 CDT