英文提示如下:
ORA-01940: cannot drop a user that is currently connected
产生原因:
由于当前用户正在连接到数据库,所以无法删除。
解决办法:
1.查看此用户的会话过程:
SQL> select sid,serial# from v$session where username = 'ESRI';
SID SERIAL#
---------- ----------
146 3132
2.结束此用户的所有会话
SQL> alter system kill session '146,3132';
System altered.
SQL> drop user ESRI cascade;
User dropped.
ORA-01940: cannot drop a user that is currently connected
产生原因:
由于当前用户正在连接到数据库,所以无法删除。
解决办法:
1.查看此用户的会话过程:
SQL> select sid,serial# from v$session where username = 'ESRI';
SID SERIAL#
---------- ----------
146 3132
2.结束此用户的所有会话
SQL> alter system kill session '146,3132';
System altered.
SQL> drop user ESRI cascade;
User dropped.