首先用户名必须用单引号引起来且必须大写,如下是失效的
1、查询用户进程
SELECT SID,SERIAL# FROM V$SESSION WHERE USERNAME='V7HIS_1';
2、删除用户进程;
ALTER SYSTEM KILL SESSION '3975,20552';
ALTER SYSTEM KILL SESSION '4256,60339';
3、重新删除用户,已经可以删除了
SQL> SELECT SID,SERIAL# FROM V$SESSION WHERE USERNAME='V7HIS_1'; no rows selected SQL> drop user v7his_1 cascade; User dropped.