merging 2 oracle databases
We have 2 production databases (on a single Sun box), one is 220.127.116.11 and the other is 18.104.22.168. We want to merge these databases so that we have only 1 database. We also plan to upgrade to the latest release 10gR2. When we do the database upgrade,
we will be migrating from solaris OS to SLES 9 on HP hardware.
The 22.214.171.124 database connects to another 126.96.36.199 (this is not our database and will not be upgraded anytime soon) database through a dblink for loading data every night.
Kindly let me know how I can merge these databases. And if I should do it before upgrade to 10gR2 or after the upgrade. Also, I would like to know if dblinks work between 10gR2 db
and 188.8.131.52 db. This is essential for our nightly load processes.
Any help is greatly appreciated and thanks in advance.