merge - update table@dblink
Hi all,
my need is to:
1) update remote table2 using dblink only if at least one of columns differs from local table1
2) insert row if it is absent in remote table2.
(2) works fine.
(1) performs in really strange way, it doesn't report any error, but row is not updated.
It works great on test server where both table1 and table2 are local.
Could someone kindly help? Please, tell me what extra information should I provide for you to know that I'm sane
The code of query is shown below:
merge into remote.table2@dblink rr
using
(
select
ID ,
NAME
from local.table1
my need is to:
1) update remote table2 using dblink only if at least one of columns differs from local table1
2) insert row if it is absent in remote table2.
(2) works fine.
(1) performs in really strange way, it doesn't report any error, but row is not updated.
It works great on test server where both table1 and table2 are local.
Could someone kindly help? Please, tell me what extra information should I provide for you to know that I'm sane
The code of query is shown below:
merge into remote.table2@dblink rr
using
(
select
ID ,
NAME
from local.table1
0