merging 2 oracle databases
We have 2 production databases (on a single Sun box), one is 22.214.171.124 and the other is 126.96.36.199. 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 188.8.131.52 database connects to another 184.108.40.206 (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 220.127.116.11 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