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