RE: DROP DEVELOPER not working

2002-10-10 Thread Jamadagni, Rajendra
Title: RE: DROP DEVELOPER not working (taking a cue from RMAN syntax) drop developer developer_name from third_floor position upside_down immediate / works for me all the time ... (sorry couldn't resist ... I have been a developer too for 8+ years) BTW 10046 will write the sql statement

RE: DROP DEVELOPER not working

2002-10-10 Thread Fink, Dan
Title: RE: DROP DEVELOPER not working I hear that they are enhancing that command in 10i. You know have the option of naming the employment position: drop manager drop user drop cow-worker etc... I recall that in Unix, the trace file is written right away, but NT waits for the process

RE: DROP DEVELOPER not working

2002-10-10 Thread Jesse, Rich
DROP COW-WORKER only works here in the Dairy State... ;) Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Thursday, October 10, 2002 11:09 AM To: Multiple recipients

RE: DROP DEVELOPER not working - 10046 trace

2002-10-10 Thread Rajesh . Rao
] October 10, cc: 2002 10:14 AMSubject: RE: DROP DEVELOPER not working - 10046 trace(Document link: Rajesh Rao

RE: DROP DEVELOPER not working - 10046 trace

2002-10-10 Thread Jamadagni, Rajendra
Title: RE: DROP DEVELOPER not working - 10046 trace execution plan comes at the end ... that's why ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't

RE: DROP DEVELOPER not working - 10046 trace

2002-10-10 Thread Rajesh . Rao
] October 10, cc: 2002 12:34 AMSubject: RE: DROP DEVELOPER not working(Document link: Rajesh Rao

RE: DROP DEVELOPER not working - 10046 trace

2002-10-10 Thread Deshpande, Kirti
Subject: RE: DROP DEVELOPER not working(Document link: Rajesh Rao) Thats a nice idea. The problem here is that the owner of the table is the one executing the drop. And its not via SQLPlus. So, the use of product_profile is also ruled out. The SQLNet tracing suggested by Robert also

RE: DROP DEVELOPER not working - 10046 trace

2002-10-10 Thread Rajesh . Rao
: @espn.com Subject: RE: DROP DEVELOPER not working - 10046 trace Sent

Re: DROP DEVELOPER not working

2002-10-10 Thread Stephane Faroult
[EMAIL PROTECTED] wrote: We have a developer here, installing a third party application, who claims one of his delete campaign process is hanging. I looked at the wait events, saw nothing, and asked him to politely to go look at the code. After much analysys, the developer now complains,

RE: DROP DEVELOPER not working - 10046 trace

2002-10-10 Thread Rajesh . Rao
: Sent by: Subject: RE: DROP DEVELOPER not working - 10046 trace [EMAIL PROTECTED

RE: DROP DEVELOPER not working - 10046 trace

2002-10-10 Thread Deshpande, Kirti
Sorry, I did not pay attention to what level trace you were generating... :( - Kirti -Original Message- Sent: Thursday, October 10, 2002 2:25 PM To: Multiple recipients of list ORACLE-L Thanks Kirti. While I cannot stop drops completely, I am thinking I could use dbms_system with the

Re: DROP DEVELOPER not working

2002-10-10 Thread Rajesh . Rao
: ole.com Subject: Re: DROP DEVELOPER not working Sent by: root

RE: DROP DEVELOPER not working - 10046 trace

2002-10-10 Thread Fink, Dan
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

RE: DROP DEVELOPER not working - 10046 trace

2002-10-10 Thread Cary Millsap
PROTECTED] October 10, cc: 2002 10:14 AMSubject: RE: DROP DEVELOPER not working - 10046 trace(Document link: Rajesh Rao) As I was investigating more on this issue, I took a close look

DROP DEVELOPER not working

2002-10-09 Thread Rajesh . Rao
We have a developer here, installing a third party application, who claims one of his delete campaign process is hanging. I looked at the wait events, saw nothing, and asked him to politely to go look at the code. After much analysys, the developer now complains, that Oracle is not executing a

Re: DROP DEVELOPER not working

2002-10-09 Thread Robert Eskridge
Is the application coming from a client? If so, sniff the packets and look for his DROP. That should be pretty conclusive. You can see the packets in a SQL*Net trace by setting TRACE_LEVEL_CLIENT=16 in sqlnet.ora. R We have a developer here, installing a third party application, who claims R

RE: DROP DEVELOPER not working

2002-10-09 Thread DENNIS WILLIAMS
Raj - What about just a normal trace file? It should show a list of the commands sent, including the drop table. Maybe killing the session will cause the O.S. to flush the trace write buffer. Just a thought. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message-

Re: DROP DEVELOPER not working

2002-10-09 Thread Jared . Still
Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:DROP DEVELOPER not working We have a developer here, installing a third party application, who claims one of his delete campaign process is hanging. I looked

Re: DROP DEVELOPER not working

2002-10-09 Thread Charlie_Mengler
: [EMAIL PROTECTED] Subject: DROP DEVELOPER not working

RE: DROP DEVELOPER not working

2002-10-09 Thread Deshpande, Kirti
PROTECTED] 10/09/2002 02:28 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:DROP DEVELOPER not working We have a developer here, installing a third party application, who claims one of his delete campaign

RE: DROP DEVELOPER not working

2002-10-09 Thread Rajesh . Rao
: Sent by: Subject: RE: DROP DEVELOPER not working [EMAIL PROTECTED