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,

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-l
Received on Mon Mar 09 2009 - 10:56:52 CDT

Original text of this message