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.