synchronisation of oracle database using snapmirror

We are considering synchronisation of records within oracle databases at two site in different countries. Currently, access to the remote site is via ftp or telnet. These oracle instances are similar but not identical and probably never will be. Now we have a project where we wish to synchronise selected records within selected tables of one of the oracle database instances (site A) to the other instance (site B). Conversely we also wish to synchronise a different set of records within selected tables of the site B oracle database instance to site A. The two sets would be clearly identify records to be synchronised in a give direction by a naming convention.

We do have a project to achieve this goal with some bespoke software. However, we see that there is a product on the market called Snapmirror which might be able to do what we require. Does anybody know whether Snapmirror can synchronise at the oracle record level or have I completely missed the point of what Snapmirror is supposed to do.

Many thanks for any help. Received on Wed Jun 21 2006 - 13:34:46 CDT