In Oracle, I keep getting this error message every single time I run a query:
ORA-30926: unable to get a stable set of rows in the source tables
Here's the query as well:
MERGE INTO table_1 a
(SELECT a.ROWID row_id, 'Y'
FROM table_1 a ,table_2 b ,table_3 c
WHERE a.mbr = c.mbr
AND b.head = c.head
AND b.type_of_action <> '6') src
ON ( a.ROWID = src.row_id )
WHEN MATCHED THEN UPDATE SET in_correct = 'Y';
Table 1 does have data in it and I've also ran the inside query (SRC), which also has data.
How can I resolve this error?