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: Nicolas Bronke <NBronke_at_TRINITY.de>
Date: Tue, 2 Mar 1999 19:02:19 +0100
Message-ID: <36dc26ed@news.uk.ibm.net> 






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


Received on Tue Mar 02 1999 - 12:02:19 CST












Original text of this message













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