首先结束了会话,图形界面下完成的,然后通过命令查询,结果如下:
select sid , serial#,status from v$session where username='aa'; SID SERIAL# STATUS
------ ---------- ----------------
32 28683 KILLED然后删除用户,出现如下错误:SQL> drop user aa cascade;
drop user aa cascade
*
ERROR 位于第 1 行:
ORA-01940: cannot drop a user that is currently connected这是为什么???谢谢大家了!!
select sid , serial#,status from v$session where username='aa'; SID SERIAL# STATUS
------ ---------- ----------------
32 28683 KILLED然后删除用户,出现如下错误:SQL> drop user aa cascade;
drop user aa cascade
*
ERROR 位于第 1 行:
ORA-01940: cannot drop a user that is currently connected这是为什么???谢谢大家了!!
SQL> alter system kill session '32,28683' ;
alter system kill session '32,28683'
*
ERROR 位于第 1 行:
ORA-00031: session ed for kill
SQL>alter user aa account lock;
再kill session
最后删除