Oracle ORA-30926

Oracle遭遇ora-30962错误

30926, 00000, "unable to get a stable set of rows in the source tables"
// *Cause: A stable set of rows could not be got because of large dml
// activity or a non-deterministic where clause.
// *Action: Remove any non-deterministic where clauses and reissue the dml.

merge的源表中有重复记录，去重后该错误消失。--处理重复记录
SELECT userid FROM t_raugh GROUP BY userid HAVING COUNT（*） > 1;DELETE t_raugh
WHERE ID IN （SELECT a.ID
FROM （SELECT b.id,
b.userid,
b.operdate,
row_number（） over（PARTITION BY b.userid ORDER BY b.operdate DESC） rn
FROM t_raugh b
WHERE b.userid IN （25468911,
25467429,
25464008,
25466351,
25464129,
25464805,
25468403,
25466240,
25467371,
25467777,
25464193,
25468734,
25464215,
25464596,
25467334,
25459985,
25468964,
25464928,
25469118,
25465790,
25466484,
25467080,
25468491,
25469197,
25467072,
25468492,
25467930,
25466768,
25463448,
25467653,
25468505,
25464075,
25468870,
25468971,
25467491）） a
WHERE a.rn > 1）更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx？tid=12判断Oracle Sequence是否存在oracle bug？ ORA-07445 ,pl/sql for in（）相关资讯 Oracle错误代码 ORA-30926

ORA-30926 及MERGE 临时表空占用问（09/17/2015 19:31:11）
Oracle Grid Control OUI-25031错（03/09/2013 09:01:36）
ORA-04091:触发器/函数不能读（02/25/2013 08:28:13）

Oracle错误代码大全（02/16/2015 21:31:57）
Oracle中登陆时报ORA-28000: the （03/06/2013 20:06:23）
Oracle 11g startup时报ORA-03113 （02/21/2013 17:25:55）

本文评论查看全部评论（0）