Re: ORA-01940: cannot drop a user that is currently connected
- From: mayur nagarsheth <mayurpnagarsheth@xxxxxxxxx>
- To: "D'Hooge Freek" <Freek.DHooge@xxxxxxxxx>
- Date: Wed, 6 Oct 2010 11:13:32 -0500
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/
Other related posts:
