Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 5192
  • Last Modified:

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"
0
pegahelpdesk1
Asked:
pegahelpdesk1
2 Solutions
 
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
 
esmail1349Commented:
You have to kill its opened sessions first then drop it.
0
 
sumit2906Commented:
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
 
pegahelpdesk1Author Commented:
thankyou
0

Featured Post

Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

Tackle projects and never again get stuck behind a technical roadblock.
Join Now