Re: DROP USER - cannot drop a user that is currently connected
- From: "Jared Still" <jkstill@xxxxxxxxx>
- To: md@xxxxxxxxxxxxx
- Date: Fri, 21 Apr 2006 08:48:04 -0700
Hmmm.
SQL> startup force restrict
that should do it. ;)
Jared
On 4/21/06, Mathias Diehl <md@xxxxxxxxxxxxx> wrote:
>
> 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
>
>
>
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Other related posts:
