RE: ORA-01940: cannot drop a user that is currently connected

From: D'Hooge Freek <Freek.DHooge@xxxxxxxxx>
To: "mayurpnagarsheth@xxxxxxxxx" <mayurpnagarsheth@xxxxxxxxx>, Bill Zakrzewski <bill@xxxxxxxxxxxx>
Date: Wed, 6 Oct 2010 17:10:36 +0200

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?


--
http://www.freelists.org/webpage/oracle-l

Follow-Ups:

Re: ORA-01940: cannot drop a user that is currently connected
From: mayur nagarsheth

References:
- ORA-01940: cannot drop a user that is currently connected
  - From: mayur nagarsheth
- Re: ORA-01940: cannot drop a user that is currently connected
  - From: Saurabh Sood
- Re: ORA-01940: cannot drop a user that is currently connected
  - From: Taral Desai
- Re: ORA-01940: cannot drop a user that is currently connected
  - From: mayur nagarsheth
- Re: ORA-01940: cannot drop a user that is currently connected
  - From: Andy Klock
- Re: ORA-01940: cannot drop a user that is currently connected
  - From: mayur nagarsheth
- Re: ORA-01940: cannot drop a user that is currently connected
  - From: Bill Zakrzewski
- Re: ORA-01940: cannot drop a user that is currently connected
  - From: mayur nagarsheth

RE: ORA-01940: cannot drop a user that is currently connected

Other related posts: