Can you merge two oracle DB's

From: jarjon <jarjon_at_gmail.com>
Date: 22 Nov 2004 08:07:30 -0800
Message-ID: <d30fcc3f.0411220807.3cac35e6@posting.google.com>

First off left me explain that I do not know anything about setting up or administrating an oracle DB. I would just like to know if this is possible, not necessarily how to do it.

We have two separate databases with the same setup/configuration/format/tables being used as an iMan/Unigraphics PDM. These two DB's only differ by the data contained in them.

Now to my question, is it possible to merge the DB's on the DB level? We have the option of exporting from one through iMan and import the other through iMan, but isn't this possible on the DB level? I was told by our ‘guru' that this wasn't possible. If we are required to import/export these records, that is a lot of work.

Thanks Received on Mon Nov 22 2004 - 10:07:30 CST