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

Hmmm.

SQL> startup force restrict

that should do it. ;)

Jared

On 4/21/06, Mathias Diehl <md_at_evoconcept.de> 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
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l