Posts Tagged ‘ORA-30926’
ORA-30926: unable to get a stable set of rows in the source tables
June 14th, 2010 No Comments Posted in Oracle Tip
I received the error “ORA-30926: unable to get a stable set of rows in the source tables”. It’s the first time I have seen this error. I was doing a merge statement affecting about 1K rows.
The problem was I was not fully matching on all the of the columns that would make the update portion of the merge statement unique. Duh! Added the additional column to my “WHEN MATCHED” criteria and everything ran fine.
