我想使用sqlplus在Oracle DB中删除一些用户,但是我收到错误:
sql> DROP USER test CASCADE; DROP USER test CASCADE * ERROR at line 1: ORA-01940: cannot drop a user that is currently connected@H_301_3@我按照SO中的链接找出了会话 – Dropping a connected user from an Oracle 10g database schema @H_301_3@但是当我运行命令时,我没有得到任何结果:
sql> select sid,serial# from v$session where username = 'test'; no rows selected@H_301_3@请帮助我在这种情况下如何删除用户。