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
- 17836 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 |
PCC-02102: Fatal error while doing C preprocessing
ORA-28605: bitmap indexes cannot be reversed
ORA-30193: reserved for future use
RMAN-06300: Report of files with less than number redundant backups
PLS-00732: Illegal overload of ellipsis in formal parameter list
ORA-34276: (MXDCL33) (Precision, Scale) arguments can only be used with a NUMBER variable or dimension.
ORA-00964: table name not in FROM list
ORA-09741: spwat: error waiting for a post.
ORA-19903: test recovery not allowed when recovering to new incarnation
ORA-13145: failed to generate range list
LFI-00120: Unable to parse root filename string.
ORA-25350: maximum number of concurrent transaction branches exceeded
Oracle Errors 
