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
- 17729 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-25503: cannot open database because the database is being quiesced
NZE-29164: External PKCS #12 wallet is not supported in FIPS mode.
ORA-24192: the property name cannot be null
NZE-29150: DES self-test failure
ORA-33092: (XSAGCOMP04) number is not the name of a MODEL in any attached analytic workspace.
LFI-00108: Open expect the file [string][string] to exist.
ORA-09311: slsleep: error temporarily suspending process
ORA-12165: TNS:Trying to write trace file into swap space.
QSM-02114: no GROUP BY clause, no aggregates and not >= 9.0 compatibility
RMAN-10039: error encountered while polling for RPC completion on channel string
ORA-04081: trigger 'string' already exists
ORA-16066: remote archival disabled
Oracle Errors 
