ORA-02291 - ORA-02063: can't find the reason why
Hello all,
I've 2 databases and would like to merge data from 1 to 2 with a dblink. I'd like to log dml errors, so, I use the clause "log errors into".
But anyway, when ORA-02291 is thrown, the logging fails and the procedure fails.
I merge in 2 from 1 and try to log in 1
Exemple:
merge into A@dblink
using(select ... from
when matched then
...
when not matched then
...
log errors into ERR$_B
ERR$_B table is in B schema. I tried to use the same table on remote schema to log errors, but same result: it fails.
When I try to merge into A from A schema with dblibnk to B, it works.
I've 2 databases and would like to merge data from 1 to 2 with a dblink. I'd like to log dml errors, so, I use the clause "log errors into".
But anyway, when ORA-02291 is thrown, the logging fails and the procedure fails.
I merge in 2 from 1 and try to log in 1
Exemple:
merge into A@dblink
using(select ... from
when matched then
...
when not matched then
...
log errors into ERR$_B
ERR$_B table is in B schema. I tried to use the same table on remote schema to log errors, but same result: it fails.
When I try to merge into A from A schema with dblibnk to B, it works.
0