Oracle encountered a ora-30962 Error
30926,000 00, "unable to get a stable set of rows in the source tables"
// * Cause: A stable set of rows cocould 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.
Duplicate records exist in the merge source table. This error disappears after deduplication.
-- Process duplicate records
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)
WHERE a. rn> 1)