Hi Peter,
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
Peter Sharman schrieb in Nachricht <36DC3CC5.81E850D_at_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 - 14:44:53 CST
