Load data from master drops tables
I have a database distributed across 2 machines.
Machine A writes to x tables and replicates those statements to B
Machine B writes to y tables and replicates those statements to A
NB. not all tables on A exist on B and vice-versa.
This all works fine, but in the case of problems, if I issue a load data from master on Machine A, it successfully updates the tables from Machine B, but also deletes on the tables on Machine A that are not on Machine B. Not desirable.
I've submitted this as a bug but does anyone know of any workarounds/alternatives.
Thanks
Peter
Subject
Views
Written By
Posted
Load data from master drops tables
3963
December 22, 2004 09:18AM
2764
December 22, 2004 10:38AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.