Re: How to copy data from one database to another

From: Peter Sharman <psharman_at_us.oracle.com>
Date: Tue, 02 Mar 1999 11:32:22 -0800
Message-ID: <36DC3CC5.81E850D@us.oracle.com>

Nicolas

The approach you discussed is also a possibility, if you're doing small data volume transfers, or perhaps small table numbers is a better way of putting it. The export/import approach is probably easier. However if you want to use an update statement, you can do it by:

Creating a database link between the two databases
Referencing the database link in your update statement (something like update a set b= (select c from d_at_dblink) will work.

Data volumes may make this perform rather slowly.

HTH. Pete

Nicolas Bronke wrote:

> Peter Sharman schrieb in Nachricht <36DC144D.8810FE16_at_us.oracle.com>...
> >Nicolas
> >
> >Two possibilities:
> >
> >1. Copy the whole database (possible since the OS and database versions
> are the
> >same)
> >
> >2. Use the export/ import tools that Oracle provides.
> >
> Hi Peter,
> this are the way I already go, but I thought there must be an easier way
> like
>
> connect to DB1 and connect to DB2
> update db1.Table set field = (select field from db2.table where ...)
>
> Kind regards
> Nicolas

Regards

Pete

Peter Sharman                              Email: psharman_at_us.oracle.com
WISE Course Development Manager            Phone: +1.650.607.0109 (int'l)
Worldwide Internal Services Education               (650)607 0109 (local)

San Francisco

"Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook
"Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA

Received on Tue Mar 02 1999 - 13:32:22 CST