...
IGNORE | Skip the change (the conflicting statement is rolled back) |
FORCE | Skip the change (the conflicting statement is kept applied) - this is different from IGNORE only if the statement acutally did change something, i.e. only if it updated/deleted more than one row. (For any other conlict: either Oracle rolls the statement back automatically due to an ORA- error or the conflict was 0 rows updated - thus no change was actually done.) |
OVERWRITE | Try again, not checking old values in the where clause |
RETRY | Try again |
ABORT | Abort the apply whole process |
RESTART | Rollback and restart the transaction |
ROLLBACK | Rollbacks the transaction |
IGNOREALL | The current and future conflicts in the same transaction will be resolved as ignore |
Listing of the conflict with the LIST CONFLICT command
To see the SQL and other details of the transaction that is causing the conflict:
...