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 database as the remote db. No persistent locking took place on the remote db. Jared