This content has been marked as final. Show 3 replies
Dou you have set up Mutli-Master replication or Master-Snapshot replication ?
If you have Master-Snapshot replication are snapshots updateable ?
When you want to do big update and don't replicate it but do it on every site tehn in general you have to:
1/ do refresh/ push all deffered transaction to get all sites to same consistent state
2/ stop replication
3/ do same update on all sites
4/ start replication again
When replication it stopped you must prevent bussines users from using the application.
Thanks for the answer,
But when I will resume th replication wouldn't it try to replicate the update? even though it was done on both sides?
What replication model are you using ? Multi-Master or Master-Snapshot.
There is package dbms_reputil with replication_on and replication_off procedures. You can disable replication in session by calling it.
I used then in Master-Snapshot configuration with updatable snapshots.
I suppose that it will work in Multi-Master configuration too.