Re: Bi-Directional replication
Date: Tue, 27 Sep 2016 18:50:41 +0000
Message-ID: <TU4PR84MB02061C732CB711C9718B5E63CCCC0_at_TU4PR84MB0206.NAMPRD84.PROD.OUTLOOK.COM>
If the table design includes an ownership column like company/org in accounting or plant in inventory then I would think VPD and application coding could be used to only allow update of specific rows from specific corresponding sites proving owning sites can be tied to the Oracle application usernames and/or IP address of the connection etc....
From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of Ryan January <rjanuary_at_gmail.com> Sent: Tuesday, September 27, 2016 2:39:33 PM To: vkeylis2009_at_gmail.com
Cc: Oracle-l
Subject: Re: Bi-Directional replication
This is impossible to accomplish at the database level. This is why it's crucial to have complete buy in from both the business and application perspective.
On Sep 27, 2016, at 1:36 PM, Vadim Keylis <vkeylis2009_at_gmail.com<mailto:vkeylis2009_at_gmail.com>> wrote:
On Sep 26, 2016, at 5:04 PM, Vadim Keylis <vkeylis2009_at_gmail.com<mailto:vkeylis2009_at_gmail.com>> wrote:
Good afternoon everyone. I am working on designing POC bi-directional replication between two data centers using dbvisit application. What are the general best practices when designing database for bidirectional replication ? What are the general design consideration should be made from your experience for bi-directional replication?
Thanks so much in advance,
[snip]
Vadim
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Sep 27 2016 - 20:50:41 CEST