oracle - Copy data from one column from database A table A to another database B table B -

oracle - Copy data from one column from database A table A to another database B table B -

i trying re-create , replace column c database table database b table b ...

please note column c exist in both databases trying replace it.

database uses different credentials , database b uses different credentials.

here trying work ... problem how handle connections within database , how can replace column

update b set b.name = (select a.name a.id = a.id , a.name not null) b.name null;

please allow know

you can utilize database link handle connections: https://docs.oracle.com/cd/b19306_01/server.102/b14200/statements_5005.htm

update b set b.name = (select a.name a@link_name a.id = a.id , a.name not null) b.name null;

oracle