Re: Can you merge two oracle DB's

"jarjon" <jarjon_at_gmail.com> wrote in message news:d30fcc3f.0411220807.3cac35e6_at_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.

Hi,

What you can do if both databases are Oracle is create a database link between the two databases. Then it is possible to execute standard SQL across that link to perform an insert / update. Like:

connect tiger/tiger_at_localdb.oracle.com

select * from customer_at_remotedb.oracle.com

gives you the data from the remote database in the local database. Look out for creating complex SQL queries across the connection as this causes problems. Best copy the data first like:

create table customer_copy as
select * from customer_at_remotedb.oracle.com

then do your merge.

Yes, it's possible.

Regards,
Steve.

>
> Thanks
Received on Mon Nov 22 2004 - 11:00:06 CST