Re: DROP USER - cannot drop a user that is currently connected
- From: "Alex Gorbachev" <gorbyx@xxxxxxxxx>
- To: md@xxxxxxxxxxxxx
- Date: Fri, 21 Apr 2006 11:08:19 +0200
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@xxxxxxxxxxxxx>:
> 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
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Best regards,
Alex Gorbachev
--
//www.freelists.org/webpage/oracle-l
Other related posts:
