Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> fabricating a ORA-02049 message

fabricating a ORA-02049 message

From: Peter Leijsten <bozzie_at_xs4all.nl>
Date: 21 Jul 2004 07:00:41 -0700
Message-ID: <2b39ddad.0407210600.2b40207b@posting.google.com>


Believe it or not, for analyzing some problem at work my boss actually wants me to to write a script that will generate a ORA-02049 (time-out: distributed transaction waiting for lock) message. From searching in the archives of this newsgroup I believe it has something to do with accessing tables at remote databases and the DISTRIBUTED_LOCK_TIMEOUT parameter. Is there an easy way to 'generate' this oracle error message using a two databases connected via a database link?

thanks in advance,
Peter Leijsten Received on Wed Jul 21 2004 - 09:00:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US