Re: What is the best way to replicate few tables between 2 Oracle 10g severs ?
Date: Mon, 20 Apr 2009 18:59:50 -0500
Message-ID: <gU7Hl.2841$fD.1583_at_flpi145.ffdc.sbc.com>
"Murty" <m_adavi_at_hotmail.com> wrote in message
news:12034b9c-cf67-4a2c-a55d-33edddc5cff5_at_r31g2000prh.googlegroups.com...
> Thanks for you all your responses....Here are some more details.
>
> 1) Near real-time <--> 2 minutes
>
> 2) Server A can have DB Link to Server B (But the other way is
> prohibited)
>
> 3) We do need access to Server-B while Server-A is up, but Server-B
> will be accessed by applications only for read-only purpose (only
> SELECTs). No direct data changes (Insert/Update/Delete) will happen on
> Server-B.
>
> We are not keen about triggers based solution becasue we can't afford
> transactions on Server-A take a hit if there is any issue with Server-
> B or the network, etc. In such cases, the changes should some how
> get queued and applied on Server-B once the issue is rectified.
>
So what's the issue with using replication with database link on Server A? Received on Mon Apr 20 2009 - 18:59:50 CDT