Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: DROP USER - cannot drop a user that is currently connected

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

From: Jared Still <jkstill_at_gmail.com>
Date: Fri, 21 Apr 2006 08:48:04 -0700
Message-ID: <bf46380604210848l2f2546aei78cb77dffb0cfc37@mail.gmail.com>


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
Received on Fri Apr 21 2006 - 10:48:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US