note
afoken
<blockquote>For example, you want to remove a row from one database table and add a corresponding row to another database table. [...]
OK, so you'd normally use SQL transactions for that, but what if these two tables are in two different databases, on two different servers, at two different sites?</blockquote>
<p><offtopic>Well, Oracle <i>can</i> do that in <i>one</i> transaction, if you use a DB link.</offtopic></p>
<p>Alexander</p>
<div class="pmsig"><div class="pmsig-747201">
--<br>
Today I will gladly share my knowledge and experience, for there are no sweeter words than "I told you so". ;-)
</div></div>
945858
945972