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
- 17700 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 |
ORA-26080: file "string" is not part of table string.string partition string
ORA-38201: assert if pin during flush
ORA-09777: osnpbr: cannot send break message
PLS-00586: a static method cannot declare a parameter named SELF
ORA-22164: delete element operation is not allowed for variable-length array
ORA-31449: invalid value for change_set_name
ORA-33918: (MAKEDCL33) You cannot define a surrogate of dimension workspace object because it is a string.
PLS-00626: partitioned/clustered/ordered parameter must be a function argument
KUP-02003: unrecognized character: string
ORA-07477: scgcmn: lock manager not initialized.
PLS-01460: Cannot access object on a remote host
ORA-02836: Unable to create temporary key file
Oracle Errors 
