SQL> drop user test cascade;
drop user test cascade
*
ERROR at line 1:
ORA-01940: cannot drop a user that is currently connected
SQL> select username,sid,serial# from v$session;
USERNAME SID SERIAL#
------------------------------ ---------- ----------
SYSMAN 118 43411
test 122 483
test 123 391
SYS 125 626
DBSNMP 129 48
SYSMAN 130 247
DBSNMP 136 113
SYSMAN 138 15
SYSMAN 141 3
143 50435
152 3
USERNAME SID SERIAL#
------------------------------ ---------- ----------
153 3
SYSMAN 158 15
160 1
161 1
162 1
163 1
164 1
165 1
166 1
167 1
168 1
USERNAME SID SERIAL#
------------------------------ ---------- ----------
169 1
170 1
SQL>alter system kill session '122,483';
SQL> drop user test cascade;
User dropped.
Oracle drop user
最新推荐文章于 2021-04-05 23:36:56 发布