I have question regarding replicating one source oracle database into two different target databases, Currently this database is already replicated using shareplex and now we want to replicate some more tables from source database into different target.
So the question is: is such configuration possible? Can we configure a new instance of shareplex to achieve that or reuse the current instance?
Thank you for your help.
You can use the same source to replicate to multiple targets and the objects replicated can be different between your two targets. This can be achieved by using what is called a compound routing map in your config file. Besides making sure that you have SharePlex installed on your additional target database, please refer to the SharePlex Administration Guide.
Please see the attached excerpt.