Re: Multi-Master AR and Foreign Keys

Oracle Distributed Systems (O'Reilly) is an excellnet book half of which is devoted to AR

rgds
Brian

"David LeJeune" <dlejeune_at_yahoo.com> wrote in message news:f329f8a7.0111200725.7d467b5a_at_posting.google.com...
> I thought I would post a follow-up message. Turns out AR initially
> copies data from the source (master definition site) into the other
> master sites specified. If data already exists in the table this may
> cause a problem. So far from what I have learned, it seems best to
> start with fresh master databases (i.e. no data) and move from there.
> Perhaps I am wrong on this account - but I jus thought someone might
> be interested in knowing.
>
> I'm somewhat surprised there is not a really good book out on the
> market that explains AR in greater detail.
>
> =-Dave L.
>
> dlejeune_at_yahoo.com (David LeJeune) wrote in message
news:<f329f8a7.0111190813.d384740_at_posting.google.com>...
> > Hi -
> >
> > Quick question. Does AR require deferrable constraints? When I
> > attempt to add an object to a multi-master AR setup, I get the
> > following error:
> >
> > ORA-02292: Integrity Constraint(<CONSTRAINT_NAME) violated - child
> > record found.
> > ORA-02266: unique/primary keys in table referenced by enabled foreign
> > keys.
> >
> > I assume the replication when I apply my change (i.e. adding the new
> > look-up table), attempts to truncate it and then insert the new data.
> > This is causing this error on the remote master site. Any ideas? Do
> > I have to make my constraints deferrable or something?
> >
> > Thanks,
> > Dave L.
Received on Tue Nov 20 2001 - 09:53:59 CST