RE: DROP DEVELOPER not working

[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 to complete. *Could be wrong on this one...only 1 cup of coffee this morning

-----Original Message-----
From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 10, 2002 5:39 AM
To: Multiple recipients of list ORACLE-L
Subject: 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 to trace file as soon as it is parsed ... it will have appropriate entry for execution as well ...

Also, see if developer is doing all this inside a script ... take a closer look for a missing / or a semicolon ...

Sometimes the best solution is an extra pair of eyes to see your code pick the person who hates you most, chances are he/she will find the most bugs in the least anount of time. It's human nature ...

Raj
______________________________________________________
Rajendra Jamadagni              MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
QOTD: Any clod can have facts, but having an opinion is an art!