About this document
Resolving ORA-30926 in MERGE SQL by Oracleconslt Oracleconslt is a document available to read on EtoBox.
- MERGE statements can experience write consistency issues and require DML restarts when duplicate rows are present in the source that match rows in the target. This can cause the statement to execute up to 5,000 times. - DML statements that update rows locked by a MERGE statement may see inconsistent data, as the rows may no longer meet the MERGE criteria by the time the lock is released. - MERGE statements track columns in the SET clause but not always columns in the ON clause, which can lead to inconsi
- Author
- Oracleconslt Oracleconslt
- Language
- EN