Merge two separate databases
Hi everyone, I have 2 oracle databases with the same tables, now I want to merge the data of those 2 databases together and remove the same data, is there any way? Please help me
1 Reply
Use a tool not code.
I don't know tools might handle this, golden gate might for example.
https://www.oracle.com/integration/goldengate/
presumptively there is dts system in oracle you can leverage.