Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id g9AMCoW00809 for ; Thu, 10 Oct 2002 17:12:50 -0500 X-ClientAddr: 209.68.248.164 Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id g9AMCmD00796 for ; Thu, 10 Oct 2002 17:12:48 -0500 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id MAA62555; Thu, 10 Oct 2002 12:54:12 -0700 (PDT) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 004E630C; Thu, 10 Oct 2002 12:41:27 -0800 Message-ID: Date: Thu, 10 Oct 2002 12:41:27 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Fink, Dan" Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Fink, Dan" Subject: RE: DROP DEVELOPER not working - 10046 trace Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Raj, This reminds me of a similar situation I encountered several years ago, perhaps there will be something in it that will help... A 3rd party app was periodically committing only 2 of 3 changes that were required. The most likely explanation of the problem was that there was an unhandled exception and the app was issuing a commit regardless. This turned out to be the case. This also would explain your situation where the app fails, but the same command run manually works. If the debug mode of the app failed to reveal any new info, I was going to turn on events to dump out an error stack in case of an error on inserts. We put together a list of probable errors on an insert (privs, bad data, unable to extend, etc.) and could have placed these events in the init.ora. The syntax is "event = trace name errorstack level 3" where error is the error number (1555 for Snapshot too old). Dan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fink, Dan INET: Dan.Fink@mdx.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).