Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-30926: unable to get a stable set of rows in the source
tables
- 2 Answers
- 17842 Views
- I also Faced
- E-Mail Answers
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 |
TNS-00206: Status Information for Interchange string:
KUP-04060: field string referenced by lobfile column string not found
PLS-00606: cursor subquery is not supported on client side in this release
ORA-01764: new update value of join is not guaranteed to be unique
ORA-29967: Cannot drop an operator binding with dependent objects
TNS-12531: TNS:cannot allocate memory
ORA-26034: Column string does not exist in stream
DRG-12410: could not process CTX EXEC tag
RMAN-10038: database session for channel string terminated unexpectedly
ORA-14002: only one GLOBAL clause may be specified
NNL-01063: Statistic counters next reset in: string
ORA-17508: I/O request buffer ptr is not alligned
Oracle Errors 
