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

From: Andy Klock <andy@xxxxxxxxxxxxxxx>
To: mayurpnagarsheth@xxxxxxxxx
Date: Mon, 4 Oct 2010 11:20:22 -0400

On Mon, Oct 4, 2010 at 10:55 AM, mayur nagarsheth <
mayurpnagarsheth@xxxxxxxxx> wrote:

> There are no jobs existing with these users. Also, it is not on RAC.
>
>
>
> That is a strange one.  Not knowing how your database is set up, is it
possible that ACOSTA connects periodically?  Could you try locking the
account, then do the delete?

alter user acosta account lock;

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

Other related posts:

» ORA-01940: cannot drop a user that is currently connected
» RE: ORA-01940: cannot drop a user that is currently connected
» RE: ORA-01940: cannot drop a user that is currently connected
» Re: ORA-01940: cannot drop a user that is currently connected
» ORA-01940: cannot drop a user that is currently connected - mayur nagarsheth
» Re: ORA-01940: cannot drop a user that is currently connected - Saurabh Sood
» Re: ORA-01940: cannot drop a user that is currently connected - Taral Desai
» Re: ORA-01940: cannot drop a user that is currently connected - mayur nagarsheth
» Re: ORA-01940: cannot drop a user that is currently connected - Andy Klock
» RE: ORA-01940: cannot drop a user that is currently connected - Goulet, Richard
» Re: ORA-01940: cannot drop a user that is currently connected - Madhu Sreeram
» Re: ORA-01940: cannot drop a user that is currently connected - mayur nagarsheth
» Re: ORA-01940: cannot drop a user that is currently connected - mayur nagarsheth
» Re: ORA-01940: cannot drop a user that is currently connected - Bill Zakrzewski
» Re: ORA-01940: cannot drop a user that is currently connected - mayur nagarsheth
» Re: ORA-01940: cannot drop a user that is currently connected - Daniel W. Fink
» RE: ORA-01940: cannot drop a user that is currently connected - D'Hooge Freek
» RE: ORA-01940: cannot drop a user that is currently connected - rajendra.pande
» Re: ORA-01940: cannot drop a user that is currently connected - mayur nagarsheth
» Re: ORA-01940: cannot drop a user that is currently connected - Daniel W. Fink
» Re: ORA-01940: cannot drop a user that is currently connected - mayur nagarsheth
» Re: ORA-01940: cannot drop a user that is currently connected - Adric Norris
» Re: ORA-01940: cannot drop a user that is currently connected - Adric Norris
» Re: ORA-01940: cannot drop a user that is currently connected - Yong Huang