How to disconnect user in Oracle 11g as a sysdba

I want to drop a user, It says "cannot drop a user that is already connected"
pegahelpdesk1Asked:
Who is Participating?
 
sumit2906Connect With a Mentor Commented:
thats right, you will find out the sid and serial# from v$session:
select sid, serial# from v$session where username = 'username';
alter system kill session 'sid, serial#' immediate;
0
 
Om PrakashCommented:
The user is still connected so you cannot drop. check the following thread for possible actions:
http://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=10354
0
 
esmail1349Connect With a Mentor Commented:
You have to kill its opened sessions first then drop it.
0
 
pegahelpdesk1Author Commented:
thankyou
0
All Courses

From novice to tech pro — start learning today.