ORA-30926: unable to get a stable set of rows in the source
tables
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-19556: required destination LOG_ARCHIVE_DUPLEX_DEST currently is deferred
ORA-09209: sftget: error reading from file
ORA-23532: tables with different synchronization mechanisms are in the same group
ORA-27124: unable to detach from shared memory segment
ORA-09819: Number exceeds maximum legal value
DRG-12700: seed word must be a single word
ORA-38455: Expression Filter index should be created by the owner.
ORA-09888: osnTXtt: txipc channel creation failed
RMAN-06143: LIKE may only be specified with COPY
NNL-01067: Trace level: number
ORA-00329: archived log begins at change string, need change string
ORA-06257: NETNTT: cannot send command line to shadow process