Re: What is the best way to replicate few tables between 2 Oracle 10g severs ?
Date: Mon, 20 Apr 2009 18:59:50 -0500
"Murty" <m_adavi_at_hotmail.com> wrote in message
> 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
> 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
> 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