CODEWITHSUNDEEP
sqloracle10g
C Deepak
C Deepak

Reputation: 1278

Merging tables across databases

I have to use merge command across different DB
i.e something like merge db1.user1.table_name to db2.user2.table_name Both are oracle databases
Is it possible ?

Upvotes: 2

Views: 822

Answers (1)

Frank Schmitt
Frank Schmitt

Reputation: 30845

Merge across a DB link works just like a "local" merge:

create database link test_dblink connect to <remote_user> 
  identified by <remote_pw> using '<remote_db_name>';


merge into user1.table1 loc_tab
using (select * from user2.table2@test_dblink) rem_tab
on (<merge_condition>)
when not matched then insert(...) values();

Upvotes: 3

Related Questions