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
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
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
]
October 10, cc:
2002 10:14 AMSubject: RE: DROP DEVELOPER not working -
10046 trace(Document link:
Rajesh Rao
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
]
October 10, cc:
2002 12:34 AMSubject: RE: DROP DEVELOPER not
working(Document link: Rajesh Rao
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
:
@espn.com Subject: RE: DROP DEVELOPER not
working - 10046 trace
Sent
[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,
:
Sent by: Subject: RE: DROP DEVELOPER not
working - 10046 trace
[EMAIL PROTECTED
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
:
ole.com Subject: Re: DROP DEVELOPER not working
Sent by:
root
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
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
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
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
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-
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
:
[EMAIL PROTECTED] Subject: DROP DEVELOPER not working
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
:
Sent by: Subject: RE: DROP DEVELOPER not
working
[EMAIL PROTECTED
21 matches
Mail list logo