drop user username cascade,提示错误,当前用户正在被使用(can not drop a user that is currently connected)
解决办法是要杀掉用户进程,再drop。
以下转载自http://teddywang.javaeye.com/blog/746696
1、查询此用户的会话进程,
SQL〉SELECT SID,SERIAL# FROM V$SESSION WHERE USERNAME='USER1';
SID SERIAL#
---------- ----------
24 25341
86 18117
2、结束此用户的所有会话
SQL>ALTER SYSTEM KILL SESSION '24,25341';
System altered.
SQL>ALTER SYSTEM KILL SESSION '86,18117';
System altered.
3、删除用户
SQL〉DROP USER USER1 CASCADE;