...
See also Data available to apply sessions for further information available to the handler.
- SQL: specify a regular expression to change the executed SQL. Note that apply will still bind the same variables to execute the modified statement, so instead of simply commenting them out you can use e.g. nvl(1, :1) = 1 instead. Simple example: "s/$/ and rownum = 1/" will add the specified text to end of the SQL statement.
- RETRY: wait a few seconds (set by variable RETRY_TIME ) and try again
- PAUSE: wait for manual user resolution
- ABORT: kill apply process
- ERROR: rollback the transaction, continue applying other transactions
...