ORA-30926: unable to get a stable set of rows in the source
tables
Answers were Sorted based on User's Feedback
Answer / ram j
This would happen in an UPDATE using MERGE statement.
The cause of this that the Inner query in MERGE ( the one
after USING clause ) returns duplicate rows and Oracle
doesnt know which value to consider for UPDATE.
The only probable solution is to remove the duplicates from
the query or strengthen the join ( ON Clause ) so that the
unique values are considered for update.
Is This Answer Correct ? | 18 Yes | 4 No |
Answer / guest
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.
Please add more information about this Error
Is This Answer Correct ? | 6 Yes | 4 No |
RMAN-08046: channel string: starting compressed full datafile backupset
ORA-13762: The string ranking measure is invalid.
PLS-01712: ANSI does not allow bind variables as INDICATORS
NNL-00260: Server-generated requests now do not require authoritative answers
RMAN-06430: recovery catalog userid cannot be SYS
ORA-19714: length for generated name longer than string
SQL*Loader-00566: partial record found at end of datafile
ORA-16608: one or more sites have warnings
PCC-01300: You are not authorized to run Pro*PL/I
QSM-01034: materialized view, string, needs a dimension level to join table, string
ORA-01903: EVENTS keyword expected
ORA-12477: greatest lower bound resulted in an invalid OS label