Re: User cannot be dropped

From: Eriovaldo Andrietta <ecandrietta_at_gmail.com>
Date: Fri, 18 Sep 2015 10:30:49 -0300
Message-ID: <CAJdDhaPcxJbGjkr4=1whof8VN+6hcar347hBCwp9D-6m+6qB4g_at_mail.gmail.com>

Hi,
The way to solve was doing : kill -9 spid. It worked fine.
Thanks.
Eriovaldo

2015-09-18 9:31 GMT-03:00 Eriovaldo Andrietta <ecandrietta_at_gmail.com>:

> Hello,
>
> I had locked and did not get sucess.
>
> I will try kill the spid via OS.
>
> Thanks.
> Eriovaldo
>
>
> 2015-09-17 22:49 GMT-03:00 Kenny Payton <k3nnyp_at_gmail.com>:
>
>> Session rolling back? If so, you could kill the spid from the os and let
>> PMON clean up the session and hand off the rollback to SMON. I suspect
>> once PMON is done you will be able to drop the user and SMON will continue
>> the remaining rollback.
>>
>> On Sep 17, 2015, at 9:13 PM, Eriovaldo Andrietta <ecandrietta_at_gmail.com>
>> wrote:
>>
>> Hello,
>>
>> I am facing this problem:
>>
>> SQL>
>> SQL>
>> SQL> DROP USER T20 CASCADE;
>>
>> DROP USER GPE_T20 CASCADE
>>
>> ORA-01940: não é possível eliminar um usuário conectado no momento
>>
>>
>> SQL> SELECT STATUS from v$session where username = 'T20';
>>
>> STATUS
>> --------
>> KILLED
>>
>>
>> It is a long time wiht the status KILLED.
>> Normaly, after a time it desapear, but in this case, it is there ... As
>> KILLED.
>>
>> Is there another way to DROP it ?
>> or I need to shutdown the database ?
>>
>>
>>
>>
>

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

Received on Fri Sep 18 2015 - 15:30:49 CEST