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.
Click Here to Expand Forum to Full Width