Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to copy data from one database to another

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:

  1. Creating a database link between the two databases
  2. 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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US