Hi All,

We have 2 production databases (on a single Sun box), one is and the other is 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 database connects to another (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 db. This is essential for our nightly load processes.

Any help is greatly appreciated and thanks in advance.