merging 2 oracle databases
We have 2 production databases (on a single Sun box), one is 184.108.40.206 and the other is 220.127.116.11. 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 18.104.22.168 database connects to another 22.214.171.124 (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 126.96.36.199 db. This is essential for our nightly load processes.
Any help is greatly appreciated and thanks in advance.
Click Here to Expand Forum to Full Width