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
- 17539 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 |
LPX-00655: Invalid output comment '~S'.
ORA-38433: index "string" could not be maintained due to "string"
ORA-10566: Test recovery has used all the memory it can use
ORA-37100: (XSUNCOMMITTED) You have one or more updated but uncommitted analytic workspaces.
ORA-07746: slemrd: invalid error message file handle
DRG-10503: table string cannot be indexed because it has no primary key
ORA-26513: push error: master proc. string$RP.string failed for trans:string seq:string
PLS-00659: constructor method must return SELF AS RESULT
LPX-00006: invalid child type for parent node
ORA-25500: database is not open
NNL-00267: Address is string
NNL-00533: ping [<server_list>] : ping one or more Names servers
Oracle Errors 
