SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Dropping connected users in Oracle DB

kumar_1302Mar 27 2013 — edited Mar 27 2013

I want to drop some users in Oracle DB using sqlplus but I am getting error:

SQL> DROP USER test CASCADE;
DROP USER test CASCADE
*
ERROR at line 1:
ORA-01940: cannot drop a user that is currently connected

But when I ran below command to know sessions connected I am not getting any results:

SQL> select sid,serial# from v$session where username = 'test';

no rows selected
Please help me how to drop users in this case.

This post has been answered by APC on Mar 27 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 24 2013

Added on Mar 27 2013

#oracle, #sql

3 comments

392 views