Re: DROP USER - cannot drop a user that is currently connected

Lock the account before killing it so that it can't reconnect. Also if session is in the middle of long transaction it might take a while to roll it back so wait a bit.

2006/4/21, Mathias Diehl <md_at_evoconcept.de>:
> Hi List,
>
> may I ask again for your support.
>
> I try to run automatic installer but fail with the message but can't drop the user:
>
>
> drop user OPENCMS cascade;
>
> -->"cannot drop a user that is currently connected"
>
> Now I googled and found:
>
> select username, sid, serial# from v$session where lower(username)='OPENCMS';
>
> What brought:
>
> USERNAME SID SERIAL#
> ------------------------------ ---------- ----------
> OPENCMS 143 148
> OPENCMS 144 623
> OPENCMS 145 19
> OPENCMS 147 378
> OPENCMS 148 609
> OPENCMS 158 764
>
>
>
>
> alter system kill session '143, 148';
>
> seem's to have no effect as the error persists.... any idea how to solve that issue?
>
> Thanx in advance
>
> Mat
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
Best regards,
Alex Gorbachev
--
http://www.freelists.org/webpage/oracle-l