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 21:45:25 +0100
Message-ID: <36dc4d27@news.uk.ibm.net>


Hi Arjan,
that was what I was looking for. Meanwhile I tested it. The dblink working fine (but only one! if I assign another to another database, all links refer to only one).
Now I have to look for replication possibility. Thank you.
Kind regards
Nicolas Bronke

Arjan van Bentem schrieb in Nachricht <36dc448d$0$24367_at_newton>...
>Nicolas Bronke wrote
>>connect to DB1 and connect to DB2
>>update db1.Table set field = (select field from db2.table where ...)
>
>You can use a database link. For some dark reason, this link should have
the
>same name as your database, which is oracle by default. Make sure that db2
is
>known in tnsnames.ora and note the quotes in " using 'db2' ":
>
Received on Tue Mar 02 1999 - 14:45:25 CST

Original text of this message

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