|
Hi, I am using dblink to read data from a remote data base,
insert these data in the local database, update the red data in the remote
database then continue to do some other work on the local database in the same
transaction. My question is : Is db link transactional; If the local transaction
failed, would the update in the remote data base roll back or if the update in
the remote data base failed, would the insert in the local data base roll back.
If not, is there a way to make db link “transactional”? Thanks |
