Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to copy data from one database to another
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
![]() |
![]() |