oracle 强制删除用户

 加上如下代码

spool   c:\killsession.sql
select   'alter   system   kill   session   ' ' '||sid|| ', '||serial#|| ' ' '; '   from  
v$session   where   username   =upper( 'mydata ');
spool   off;
@c:\killsession.sql
drop   user   mydata   cascade;