ORA-01940: 无法删除当前连接的用户（解决办法）

最新推荐文章于 2024-08-10 02:17:32 发布

luozhonghua2000

最新推荐文章于 2024-08-10 02:17:32 发布

阅读量1.3k

点赞数

文章标签： oracle dba

本文链接：https://blog.csdn.net/luozhonghua2014/article/details/46490237

版权

SQL调优专栏收录该内容

21 篇文章 0 订阅

订阅专栏

SQL> drop user lisi;
drop user lisi
ORA-01940: 无法删除当前连接的用户

SQL> select username,sid,serial# from v$session where username is not null;
USERNAME                              SID    SERIAL#
------------------------------ ---------- ----------
AAA                                    12         28
AAA                                    13        186
AAA                                    21        204
AAA                                    24         45
AAA                                   143        206
LISI                                  145        487
6 rows selected

SQL> select username,sid,serial# from v$session where username='LISI';
USERNAME                              SID    SERIAL#
------------------------------ ---------- ----------
LISI                                  145        487

SQL> alter system kill session '145,487';
System altered

SQL> drop user lisi cascade;
SQL> 
User dropped

SQL> select username,sid,serial# from v$session where username='LISI';
USERNAME                              SID    SERIAL#
------------------------------ ---------- ----------
LISI                                  145        487

SQL> select username,sid,serial# from v$session where username is not null;
USERNAME                              SID    SERIAL#
------------------------------ ---------- ----------
AAA                                    12         28
AAA                                    21        204
AAA                                    24         45
AAA                                   143        206
LISI                                  145        487

SQL> alter system kill session'145,487';
System altered

SQL> drop user lisi cascade;
drop user lisi cascade
ORA-01918: 用户 'LISI' 不存在

SQL> select username,sid,serial# from v$session where username is not null;
USERNAME                              SID    SERIAL#
------------------------------ ---------- ----------
AAA                                    12         28
AAA                                    21        204
AAA                                    24         45
AAA                                   143        206
LISI                                  145        487

SQL> select username,sid,serial# from v$session where username is not null;
USERNAME                              SID    SERIAL#
------------------------------ ---------- ----------
AAA                                    12         28
AAA                                    21        204
AAA                                    24         45
AAA                                   143        206
LISI                                  145        487