Locking over a DB link
From: Jason Heinrich <jheinrichdba_at_gmail.com>
Date: Tue, 9 Dec 2008 14:47:43 -0600
Message-ID: <b32e774d0812091247k26efed4er9c689a6f05208ddc@mail.gmail.com>
Date: Tue, 9 Dec 2008 14:47:43 -0600
Message-ID: <b32e774d0812091247k26efed4er9c689a6f05208ddc@mail.gmail.com>
I was wondering if it was possible for SQL similar to the following to cause
a lock to be created on the remote database:
insert into localtable
(select columns from remotetable_at_dblink where <some condition>);
My first reaction was no, but I thought I remembered locking oddities over links being discussed before. So far I haven't found anything useful in my searches though.
-- Jason Heinrich -- http://www.freelists.org/webpage/oracle-lReceived on Tue Dec 09 2008 - 14:47:43 CST