Oracle ORA-30926

Source: Internet
Author: User

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)

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.