oracle无法删除当前已连接用户

如果在删除用户时提示:无法删除当前已连接的用户,则表明当前用户在数据库session中有连接,可以查询出来并kill掉这些连接

SQL>select username, sid, serial# from v$session where username=’用户名’;

结果:

username                              sid                serial#

用户名                                     151                  51

SQL>alter system kill session ‘151, 51’;

//from http://blog.csdn.net/fm0517/article/details/5338021

This entry was posted in Computer, Database. Bookmark the permalink.

Leave a Reply

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 / Change )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s