Oracle数据库ORA-01940: 无法删除当前已连接的用户

Posted: 九月 6, 2011 in oracle

Oracle数据库的操作中,出现了ORA-01940: 无法删除当前已连接的用户的错误,该如何解决呢?本文我们就来介绍一下解决方案,希望能够对您有所帮助.

SQL> drop user a cascade;

drop user a cascade

*

ERROR 位于第 1 行:

ORA-01940: 无法删除当前已连接的用户

解决方法:

SQL> select username,sid,serial# from v$session;

USERNAME                              SID    SERIAL#

—————————— ———- ———-

1          1

2          1

3          1

4          1

5          1

6          1

7          1

SYS                               8          3

A                                   9          4

已选择9行.

SQL> alter system kill session’9,4′;

系统已更改.

SQL> drop user a cascade;//删除用户以及用户表空间下所有对象

用户已丢弃.

关于Oracle数据库ORA-01940: 无法删除当前已连接的用户的相关知识就介绍到这里了,希望本次的介绍能够对您有所收获!

发表评论

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / 更改 )

Twitter picture

You are commenting using your Twitter account. Log Out / 更改 )

Facebook photo

You are commenting using your Facebook account. Log Out / 更改 )

Google+ photo

You are commenting using your Google+ account. Log Out / 更改 )

Connecting to %s