1、先锁定用户、然后查询进程号,最后删除对应的进程、再删除对应的用户
alter user FMIS9999 account lock;
--SELECT * FROM V$SESSION WHERE USERNAME='FMIS9999';
--alter system kill session 'xx,xx';
--合并拼接查询进程号并删除对应进程的sql
SELECT 'alter system kill session '''|| sid || ',' || serial# || '''' FROM V$SESSION WHERE USERNAME='FMIS9999';
drop user FMIS9999 cascade
;
2.shutdown掉数据库,再重启
2.shutdown掉数据库,再重启