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"
Who is Participating?

Improve company productivity with a Business Account.Sign Up

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;
Om PrakashCommented:
The user is still connected so you cannot drop. check the following thread for possible actions:
esmail1349Connect With a Mentor Commented:
You have to kill its opened sessions first then drop it.
pegahelpdesk1Author Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.