Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Synchronizing 2 tables in same database -how ?
Hi,
See the background on a previous post on this subject.
I saw by the way that when you declare the replicated object, you type in the database link, but if i do a databaselink that points to the same SID, then it may work. I will give this a try.
/Christian
"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:<bpgsiu$i60$1$830fa7b3_at_news.demon.co.uk>...
> It seems an unusual exercise, would you care to explain
> why you want to do it.
>
> One options (which I haven't tried) is to create loopback
> database links, so the database appears to be two other
> databases - then you might be able to do multi-master
> replication.
>
> More simply, and less resource intensive perhaps, create
> triggers on the tables to do synchronized locking and
> updates by primary key. Set a global variable in each
> trigger to say 'I am coming from a trigger' so that the
> triggered update to one doesn't replicate itself back in
> an infinite loop. You may run into some interesting
> scalability and deadlock problems, of course.
>
>
> --
> Regards
>
> Jonathan Lewis
> http://www.jlcomp.demon.co.uk
Received on Thu Nov 20 2003 - 04:48:30 CST