DROP USER - cannot drop a user that is currently connected

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 Received on Fri Apr 21 2006 - 03:52:22 CDT