ORA-30926 unable to get a stable set of rows in the source tables

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.

 

getting more than one records to update single row

***there is a restriction that multiple updates to the same row in the destination table is not allowed and will raise ORA-30926.

Action: Remove any non-deterministic where clauses and reissue the dml.

Solution 

use distinct in select query

check duplicate record

Another Issue Cause

Merge Parallel is not supporting when query is using index.

Check explain plan. It is not using Parallel hint as using index.

If use full hint with paralel then it start using Parallel.

that time getting this error  ORA-30926 unable to get a stable set of rows in the source tables

Solution

Remove Parallel hint