Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-02049: timeout: distributed transaction waiting for lock

user5716448Oct 25 2016 — edited Oct 31 2016

Hi,

have a 10.2.0.4 oracle database and etl which rusn each day normally fine and got

ORA-02049: timeout: distributed transaction waiting for lock despite the particular sql concerned not looking to access over db link.

error the sql concerned doesn't access tables residing on a remote database it is part of a very large transaction which looks to read data from a remote db link - no updates and insert data on local tables though the exact sql executing  failed on

purely insert into loacl table from another local table

Any thoughts?

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 28 2016
Added on Oct 25 2016
#general-database-discussions
14 comments
22,734 views