问：如何用SYSTEM删除一个CURRENTLY CONNECTED 的用户

一个学生

Connected to:
Oracle7 Server Release 7.3.4.0.1 - Production
With the distributed, replication and parallel query options
PL/SQL Release 2.3.4.0.0 - Production

SQL>; drop user yyttddss cascade;
drop user yyttddss cascade
*
ERROR at line 1:
ORA-01940: cannot drop a user that is currently connected

dragondb

1 kill sessin
2 drop user

fish617

v$session中，kill掉该用户的sid,serial#
alter system kill session 'sid,serial#';

then drop user;

binary

如果可能，最简单的做法就是 startup force ，然后马上 drop user

一个学生

[quote]原帖由 "binary"]如果可能，最简单的做法就是 startup force ，然后马上 drop user[/quote 发表：

这个方法好。

sshd

dragondb's method is recommended, but binary is NOT