学习是一种信仰。
分类: Oracle
2013-03-27 13:27:30
SQL> drop user pis_product cascade;
drop user pis_product cascade
*
ERROR at line 1:
ORA-01940: cannot drop a user that is currently connected
SQL> select sid,serial# from v$session where username='PIS_PRODUCT';
SID SERIAL#
---------- ----------
176 2056
181 4492
SQL> alter system kill session '176,2056';
System altered.
SQL> alter system kill session '181,4492';
alter system kill session '181,4492'
*
ERROR at line 1:
ORA-00030: User session ID does not exist.
SQL> select sid,serial# from v$session where username='PIS_PRODUCT';
SID SERIAL#
---------- ----------
176 2056
SQL> alter system kill session '176,2056';
System altered.
SQL> select sid,serial# from v$session where username='PIS_PRODUCT';
SID SERIAL#
---------- ----------
176 2056
SQL> drop user pis_product cascade;
User dropped.