select a.username,a.sid,a.serial# from v$session a 找到SESSION得SID喝SERIAL 然后alter system kill session '129,14933'--‘SID,SERIAL’OK......不过删除数据库要先关闭吧,SHUTDOWN IMMEDIATE或者SHUTDOWN ABORT
我报的具体错误是这样的SQL*Plus: Release 11.1.0.6.0 - Production on Wed Aug 19 13:51:10 2009Copyright (c) 1982, 2007, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production With the Partitioning, Oracle Label Security, OLAP, Data Mining, Oracle Database Vault and Real Application Testing optionsdrop user sysdb cascade * ERROR at line 1: ORA-01940: cannot drop a user that is currently connected Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit P roduction With the Partitioning, Oracle Label Security, OLAP, Data Mining, Oracle Database Vault and Real Application Testing options
select a.username,a.sid,a.serial#
from v$session a
找到SESSION得SID喝SERIAL
然后alter system kill session '129,14933'--‘SID,SERIAL’OK......不过删除数据库要先关闭吧,SHUTDOWN IMMEDIATE或者SHUTDOWN ABORT
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing optionsdrop user sysdb cascade
*
ERROR at line 1:
ORA-01940: cannot drop a user that is currently connected
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit P
roduction
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options