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
- 17685 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 |
RMAN-08589: channel string: starting datafile conversion
DRG-12302: invalid column list
QSM-01073: materialized view, string, has a join not found in query
RMAN-08511: piece handle=string tag=string
DRG-50933: parser hash insert failure
ORA-30135: OCI Thread operation fails
ORA-24148: cannot drop rule string.string with dependents
ORA-13784: cannot accept SQL profiles for all statements in the "SQL Tuning Set"
ORA-15046: ASM file name 'string' is not in single-file creation form
ORA-39091: unable to determine logical standby and streams status
ORA-31623: a job is not attached to this session via the specified handle
ORA-08180: no snapshot found based on specified time
Oracle Errors 
