RE: Locking over a DB link
Date: Tue, 9 Dec 2008 16:11:32 -0500
Message-ID: <23C4836D8E9C5F4280A66C0C247BC16F20D48811@US-BOS-MX011.na.pxl.int>
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: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] 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 -- http://www.freelists.org/webpage/oracle-lReceived on Tue Dec 09 2008 - 15:11:32 CST