Yes I have trace it and even forwarded to Oracle support for analysis. But nothing came out. I have also attached the trace in my earlier mail. On Wed, Oct 6, 2010 at 10:10 AM, D'Hooge Freek <Freek.DHooge@xxxxxxxxx>wrote: > Have you tried to trace the sql statement as was suggested? > > > Freek D'Hooge > Uptime > Oracle Database Administrator > email: freek.dhooge@xxxxxxxxx > tel +32(0)3 451 23 82 > http://www.uptime.be > disclaimer: www.uptime.be/disclaimer > --- > From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] > On Behalf Of mayur nagarsheth > Sent: woensdag 6 oktober 2010 16:57 > To: Bill Zakrzewski > Cc: Oracle-L@xxxxxxxxxxxxx > Subject: Re: ORA-01940: cannot drop a user that is currently connected > > Bouncing is mot possible as it is a production database. > > No flashback enabled. > On Wed, Oct 6, 2010 at 9:53 AM, Bill Zakrzewski <bill@xxxxxxxxxxxx> wrote: > Have you (are you able to?) bounced the database and then attempt to drop > the user? > > > -- Thanks n Regards, Mayur Nagarsheth Cell : (+1)214-364-8271 http://www.linkedin.com/in/mayurnagarsheth http://lyle.smu.edu/~mnagarshet/