Re: Locking over a DB link

From: Jason Heinrich <>
Date: Tue, 9 Dec 2008 15:26:05 -0600
Message-ID: <>

Hmm. I think I need to brush up on the different types of locks. In the meantime, could this remote lock prevent the logical standby from applying DML to those tables?

On Tue, Dec 9, 2008 at 3:11 PM, Goulet, Richard <>wrote:

> OH DEAR, talk about going back in time!! Yes, this type of transaction
> will cause a lock on the remote database, similar to if you were doing the
> same thing on the local database. Oracle does this so that no one changes
> the definition of the table in mid stream. Now if I remember correctly the
> lock does not get released till either the local session ends or the
> database link is closed.
> *Dick Goulet***
> Senior Oracle DBA
> PAREXEL International
> 978.313.3426
> * information transmitted in this communication is intended only for the
> person or entity to which it is addressed and may contain confidential
> and/or privileged material. Any review, retransmission, dissemination or
> other use of, or taking of any action in reliance upon, this information by
> persons or entities other than the intended recipient is prohibited. If you
> received this in error, please destroy any copies, contact the sender and
> delete the material from any computer.*
> ------------------------------
> *From:* [mailto:
>] *On Behalf Of *Jason Heinrich
> *Sent:* Tuesday, December 09, 2008 3:48 PM
> *To:* Oracle List
> *Subject:* Locking over a DB link
> 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

Received on Tue Dec 09 2008 - 15:26:05 CST

Original text of this message