Oracle Streams over unreliable network
Essentially we want to support satellite branches of our application, each containing distinct subsets of the head-office data, and the ability for the satellite branch to continue running in the event of communication failure with head-office. We are thinking about using Oracle streams for to replicate data between sites but I am having difficulty finding out how Streams copes with intermittent network failure. We ideally want it to buffer changes and retry until it succeeds.