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
- 17726 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 |
QSM-02088: mv omits at least one grouping key from the select list
ORA-29313: tablespace 'string' cannot be imported twice
TNS-12668: Dedicated server: outbound protocol does not support proxies
LRM-00108: invalid positional parameter value 'string'
ORA-32053: operation not supported
ORA-14050: invalid ALTER INDEX MODIFY PARTITION option
ORA-00065: initialization of FIXED_DATE failed
PLS-00706: Exception string cannot be used as prefix of a selected component
ORA-24131: table string has incorrect columns
ORA-23488: propagation mode "string" for "string" is not allowed for this operation
LFI-00104: Read operation failed.
ORA-02383: illegal cost factor
Oracle Errors 
