Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-30926

774875Nov 11 2011 — edited Nov 11 2011
Hi,

I have a merge statement which occasionally errors out with ORA-30926.

This is what I find as the description for the error:
    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 large dml activity or a non-deterministic where clause.
 
    Action: Remove any non-deterministic where clauses and reissue the dml.
Now if the issue was because of a non-deterministic where clause I should hit the error every time the merge is run, right?

So, now I think it has to be the other reason from the above description (i.e. due to large DML activity). Can someone please elaborate this? Like, if it is large amount of DML activity in the database, or it is large DMLs on the source table(s) (the ones under the USING clause), or the target table. And how do I get this fixed?

Thanks,
CJM
This post has been answered by oradba on Nov 11 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 9 2011
Added on Nov 11 2011
1 comment
332 views