正在连接的用户不能删除,确实要删除的话,如下 1、select sid,serial#,username from v$session where user='USERNAME'; 2、alter system kill session 'sid,serial#'; 3、drop user username cascade;
1、select sid,serial#,username from v$session where user='USERNAME'; 2、alter system kill session 'sid,serial#'; 3、drop user username cascade;GOOD!
select 'alter system kill session ''' || sid || ',' || serial# || ''';' from v$session where username = 'GW';把上面的查询结果执行一下。
1、select sid,serial#,username from v$session where user='USERNAME';
2、alter system kill session 'sid,serial#';
3、drop user username cascade;
2、alter system kill session 'sid,serial#';
3、drop user username cascade;GOOD!
from v$session
where username = 'GW';把上面的查询结果执行一下。