问题一:
操作表格时报错误:ORA-00054: 资源正忙,要求指定 NOWAIT的处理(ORA-00054: resource busy and acquire with NOWAIT specified)
解决方法:
1、使用select session_id from v$locked_object;
–查询被锁定的session_id
2、使用SELECT sid, serial#, username, osuser FROM v$session where sid = 822;
–查询被锁定的session状态
3、使用alter system kill session ‘, <serial#>’;
–KILL掉被锁定的进程资源
4、刷新后即可继续操作表格
问题二:
查询oracle数据库数据时报错误:ORA-00918:未明确定义列(ORA-00918: column ambiguously defined)
举例:
select factory_id, factory_id fr