Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2002
    Location
    USA-CA
    Posts
    36

    Red face Unanswered: ORA-02049: timeout: distributed transaction waiting lock...

    Hi guys,

    I need your advice.

    I run some query:

    update TABLE_A a
    set a.CUSTOMER_TYPE = (select b.Customer_Type
    from TABLE_B b
    where a.KEY = b.KEY)
    where a.CUSTOMER_TYPE = ' '

    It returns Error Message:
    "ORA-02049: timeout: distributed transaction waiting lock..."

    What's the problem?
    Is it something wrong in my query?
    Do you know how to fix it?

    Any ideas appreciated.

    Thanks in advance,
    John.






    John Smith

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: ORA-02049: timeout: distributed transaction waiting lock...

    It looks like TABLE_A is a synonym that points to a table in another database (TABLE_A@SOMEWHERE). And someone already has a lock on one of the rows you are trying to update, so you can't do it. I think all you can do is wait, then try again when hopefully the other user has committed.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •