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;

Other related posts: