查询session
select * from v$session where username='SPES'
alter system kill session'159,3'
再删除就可以了。
相关文章
- oracle--drop user 和 drop user cascade 的区别【转载】
- oracle数据库删除用户：drop user scott和drop user scott cascade的区别
- Oracle中drop user和drop user cascade的区别
- Oracle中 drop user 和 drop user cascade 的区别
- drop user与drop user cascade的区别
- MySQL调用函数报错：ERROR 1370 (42000): execute command denied to user 'test'@'localhost' for routine 'mydb.myfunc'
- GTID复制报错处理：Last_Error: Error 'Can't drop database 'test'; database doesn't exist' on query
- drop user和drop user cascade的区别
- drop user test cascade 报错
- 请教drop user pubr cascade 执行时间为什么特别长？