Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Multi-master replication in 9i - updates aren't automatically propagating--HELP!
Every five seconds is asking for trouble (once you get your interval
straightened out). If your master sites are more than two feet apart you're
setting yourself up for conflicts.
"Jamie" <jamie.tinker_at_transcore.com> wrote in message
news:44a974b5.0211220721.4d21a31e_at_posting.google.com...
> I am attempting to set up a replicated environment in Oracle 9i. I
> have all the replication set up properly (I think), yet when I make an
> update to a replicated table, the update doesn't automatically
> propagate. I can see the transaction in the replication
> administration deferred queue, and if I manually push the transaction
> it works, but it doesn't automatically send the transaction across. I
> have a schedule set up to push every 5 seconds (sysdate + 5/(60*60*24)
> ). I don't know what is going on. Why won't it use the schedule to
> push the transactions? Has anyone ran into this problem??
>
> Any ideas would be GREATLY appreciated.
>
> Thanks,
> Jamie Tinker
Received on Sat Nov 23 2002 - 16:37:21 CST
![]() |
![]() |