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 |
NNL-00875: Average update processing time: string
ORA-02493: invalid file increment size in NEXT clause
QSM-02070: PCT not supported with this type of partitioning
ORA-25255: incorrect subscription string string
LSX-00242: bad Boolean "~S"
IMG-02005: 2FF05 - incorrect color specification
DRG-51030: wildcard query expansion resulted in too many terms
RMAN-08550: autobackup search outside recovery area not attempted because DBID was not set
NID-00330: The following datafiles are offline immediate:
QSM-01096: Materialized view with grouping sets contains duplicates
ORA-36950: (XSFCAST22) The list of string values cannot have more than number members. You supplied number.
ORA-16609: one or more resources have failed