question on ORA-02049: timeout: distributed transaction waiting for lock
From: Guang Mei <gmei_at_prospectiv.com>
Date: Mon, 9 Mar 2009 11:56:52 -0400
Message-ID: <58E25299ABD54EEC9FA1753900204A3A_at_gmei>
Hi,
Date: Mon, 9 Mar 2009 11:56:52 -0400
Message-ID: <58E25299ABD54EEC9FA1753900204A3A_at_gmei>
Hi,
Oracle 10gR2.
We have a croned MV refresh process (originated from Test, copying T1 data from Production to Test) that a couple of time fails with this message:
BEGIN dbms_mview.refresh('T1'); END;
*
ERROR at line 1:
ORA-12008: error in materialized view refresh path ORA-02049: timeout: distributed transaction waiting for lock ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2255 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2461 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2430 ORA-06512: at line 1
My question is, does the lock is on the T1 of Test or Production DB? I would think there was some process that was updating T1 table on Production while this MV refresh started, Am I right?
TIA
Guang Mei
www.eversave.com
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Mar 09 2009 - 10:56:52 CDT