Re: Locking over a DB link
From: Jason Heinrich <jheinrichdba_at_gmail.com>
Date: Tue, 9 Dec 2008 14:54:17 -0600
Message-ID: <b32e774d0812091254u63afe492t24e0a9c1cf4227dd@mail.gmail.com>
Date: Tue, 9 Dec 2008 14:54:17 -0600
Message-ID: <b32e774d0812091254u63afe492t24e0a9c1cf4227dd@mail.gmail.com>
Sorry, forgot the db info:
Both databases are 10.2.0.3 EE on Windows 2003. Remote database is a logical standby.
On Tue, Dec 9, 2008 at 2:47 PM, Jason Heinrich <jheinrichdba_at_gmail.com>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_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
>
-- Jason Heinrich -- http://www.freelists.org/webpage/oracle-lReceived on Tue Dec 09 2008 - 14:54:17 CST