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
- 17571 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-29828: invalid name for implementation type
ORA-01226: file header of log member is inconsistent with other members
ORA-37126: (XSCCOMP01) The COMPRESSED COMPOSITE workspace object can only be used as a base of a single variable.
AMD-00143: View name "string" must be fully qualified with the Owner.
ORA-16081: insufficient number of processes for APPLY
ORA-16004: backup database requires recovery
NZE-29024: Certificate validation failure
RMAN-06911: only one PARALLEL or NOPARALLEL clause may be specified
ORA-07497: sdpri: cannot create trace file 'string'; errno = string.
ORA-28006: conflicting values for parameters string and string
NZE-28839: no persona descriptor
DRG-10702: cannot create or modify preference in another user's schema
Oracle Errors 
