![](https://img-blog.csdnimg.cn/20201014180756919.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Oracle
文章平均质量分 77
赵大土
是非审之于己,毁誉听之于人,得失安之于素,成败归之于零。
展开
-
Oracle:ORA-01795: maximum number of expressions in a list is 1000
ORA-01795: maximum number of expressions in a list is 1000SQLMyBatis优化思考最近测试老师反映一个页面加载异常,查看日志发现返回Cause: java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000,意思是说Oracle的in查询中数据不能超过1000,解决方案也不复杂,就是拆分in查询语句SQL原句sele原创 2021-07-01 13:35:35 · 3935 阅读 · 2 评论 -
Oracle:ORA-00054:resource busy and acquire with nowait specified
问题今天在PL-SQL Developer中使用drop table删除一个表时提示ORA-00054:resource busy and acquire with nowait specified,原因是之前使用了select for update命令没有commit就关闭了,导致该表被锁住方案使用SYSDBA账户登录执行一下命令查看数据库锁信息select t1.username, t1.sid, t1.serial#, t1.logon_timefrom v$session t1, v#lo原创 2020-12-16 13:55:00 · 303 阅读 · 0 评论