Re: User cannot be dropped

From: Kenny Payton <k3nnyp_at_gmail.com>
Date: Thu, 17 Sep 2015 21:49:48 -0400
Message-Id: <A9830254-464F-407D-A799-FC804B32107C_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 - 03:49:48 CEST

Original text of this message