Make Your Microsoft Dynamics Investment Count & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.
merge into tropics_policy.zip_code zc using tmp_zip_code tzc on ( zc.zip = tzc.zip_code and zc.state = tzc.state ) when matched then update set zc.auditor_id = tzc.auditor, zc.customer_service_rep = tzc.csr, zc.loss_control_counselor = tzc.lp_rep, zc.marketing_rep = tzc.marketing_rep, zc.underwriting_rep = tzc.uw Error message I am getting: ORA-30926 unable to get a stable set of rows in the source tables Cause: A stable set of rows could not be got because of a large amount of DML activity or a non-deterministic where clause. Action: Remove any non-deterministic where clauses and reissue the DML.
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.