场景:当我们要删除一个用户时,如果数据库正在被连接,则会报错,如下: ORA-01940:无法删除正在连接的用户 解决措施如下: 1、查询连接会话 select username, sid, serial# from v$session where username='SCE_IN'; 2、删掉会话 alter system kill session'21,1016'; 3、删除用户 drop
手动清空jbpm3.2中数据库的表,有限表之间的关联,无法删除,以下是我记录清空数据表的先后顺序,在这记录下: delete from jbpm_log; delete from jbpm_variableinstance; delete from jbpm_taskinstance; delete from jbpm_tokenvariablemap; delete from