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