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-06137: must have recovery catalog for REPORT SCHEMA AT TIME
DRG-11307: operation cannot be performed on an index
ORA-13757: "SQL Tuning Set" "string" is active.
DRG-11823: Not Found
PLS-00425: in SQL, function argument and return types must be SQL type
ORA-23328: mview base table "string"."string" differs from master table "string"."string"
PCC-00010: Statement out of place at line number in file string
ORA-00092: LARGE_POOL_SIZE must be greater than LARGE_POOL_MIN_ALLOC
ORA-03203: concurrent update activity makes space analysis impossible
ORA-13137: failed to generate tablespace sequence number
DRG-12511: use ctx_ddl.create_stoplist to create stoplists
DRG-13104: indexes do not have equivalent settings for string