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

From: mayur nagarsheth <mayurpnagarsheth_at_gmail.com>
Date: Wed, 6 Oct 2010 09:57:17 -0500
Message-ID: <AANLkTik+8GVftzB3Vm3u0t2wWFXMSmWt=A8QJYF5fGzd_at_mail.gmail.com>



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_at_intactus.com> wrote:

> Have you (are you able to?) bounced the database and then attempt to drop
> the user?
>
>
> On Oct 6, 2010, at 10:46 AM, mayur nagarsheth wrote:
>
> This user account has been locked since 1 month. No active connections, no
> active sessions, no db links, no objects are being owned by this user. I
> revoked all the privileges this (ACOSTA) user had just to be on safer side.
> But nothing works :(
>
>
> On Mon, Oct 4, 2010 at 10:20 AM, Andy Klock <andy_at_oracledepot.com> wrote:
>
>>
>>
>> On Mon, Oct 4, 2010 at 10:55 AM, mayur nagarsheth <
>> mayurpnagarsheth_at_gmail.com> 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;
>>
>
>
>
> --
> Thanks n Regards,
> Mayur Nagarsheth
> Cell : (+1)214-364-8271
> http://www.linkedin.com/in/mayurnagarsheth
>
> http://lyle.smu.edu/~mnagarshet/ <http://lyle.smu.edu/%7Emnagarshet/>
>
>
>

-- 
Thanks n Regards,
Mayur Nagarsheth
Cell : (+1)214-364-8271
http://www.linkedin.com/in/mayurnagarsheth

http://lyle.smu.edu/~mnagarshet/

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Oct 06 2010 - 09:57:17 CDT

Original text of this message