Re: Locking over a DB link

  • From: "Jared Still" <jkstill@xxxxxxxxx>
  • To: jheinrichdba@xxxxxxxxx
  • Date: Tue, 9 Dec 2008 14:24:49 -0800

On Tue, Dec 9, 2008 at 12:47 PM, Jason Heinrich <jheinrichdba@xxxxxxxxx>wrote:

> 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@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.
Why not test it?

I just ran a test of this using a 9i database as the local db, and a 10g
as the remote db.

No persistent locking took place on the remote db.


Other related posts: