Re: User cannot be dropped

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