Hope you can help me. I need to know how is it possible to merge 2 oracle databases together. Both databases have exactly the same tables and objects.
Here is the scenario. One database is the production server database which is used in a multi-user environment. I have some users that need a copy of this production database on their laptops, to be updated every week so they can use it in the field. Is it possible to import a full dump of the production db to the local databases on their machines and merge the data with last weeks data..and so on?
Or, do i have to always create a new blank database on the laptops and import the latest dump and dispose of the local db of last week?
This would be too much work.
I really am trying to find a way of synchronising the databases.
Support for Disconnected Snapshot Environments
Snapshot replication allows users to remotely store all or a subset of replicated data from a master site in a disconnected environment. This scenario is typical of sales force automation systems where an individual's laptop (a disconnected device) stores a subset of data related to the individual salesperson.
Last edited by efrijters; 09-16-2003 at 03:02 PM.
An expert is one who knows more and more about less and less until he knows absolutely everything about nothing.