Solved

How to disconnect user in Oracle 11g as a sysdba

Posted on 2010-09-08
4
4,424 Views
Last Modified: 2013-12-19
I want to drop a user, It says "cannot drop a user that is already connected"
0
Comment
Question by:pegahelpdesk1
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 22

Expert Comment

by:Om Prakash
ID: 33624703
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
 
LVL 1

Assisted Solution

by:esmail1349
esmail1349 earned 62 total points
ID: 33624743
You have to kill its opened sessions first then drop it.
0
 
LVL 7

Accepted Solution

by:
sumit2906 earned 63 total points
ID: 33625040
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
 

Author Comment

by:pegahelpdesk1
ID: 33625115
thankyou
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows how to recover a database from a user managed backup
Suggested Courses

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question