Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2002

    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 Smith

  2. #2
    Join Date
    Sep 2002
    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