All keywords are case-insensitive.
...
The DEFAULT conflict handler will not be applied to existing prepared (replicated) tables. The DEFAULT conflict handler will only be applied to tables that are prepared after the DEFAULT conflict handler is set. To change the conflict handler for existing prepared tables, each table has to be individually set using FOR TABLE conflict handler.
Example:
| No Format | ||
|---|---|---|
| ||
dbvrep> SET_CONFLICT_HANDLERS FOR TABLE SCOTT.DEPT FOR UPDATE on NO_DATA TO OVERWRITE Connecting to running apply: [The table called SCOTT.DEPT on source is handled on apply (APPLY) as follows: UPDATE (error): handler: RETRY logging: LOG UPDATE (no_data): handler: OVERWRITE logging: LOG UPDATE (too_many): handler: RETRY logging: LOG DELETE (error): handler: RETRY logging: LOG DELETE (no_data): handler: RETRY logging: LOG DELETE (too_many): handler: RETRY logging: LOG INSERT (error): handler: RETRY logging: LOG TRANSACTION (error): handler: RETRY logging: LOG] dbvrep> |
...
| Anchor | ||||
|---|---|---|---|---|
|
SHOW_CONFLICT_HANDERSHANDLERS. Shows current setting of conflict handlers for given table (schema.name refers to table at MINE).
...
| No Format | ||
|---|---|---|
| ||
dbvrep> show_conflict_handlers for table scott.dept
The table called SCOTT.DEPT on source is handled on apply (APPLY) as follows:
UPDATE (error): handler: RETRY logging: LOG
UPDATE (no_data): handler: RETRY logging: LOG
UPDATE (too_many): handler: RETRY logging: LOG
DELETE (error): handler: RETRY logging: LOG
DELETE (no_data): handler: RETRY logging: LOG
DELETE (too_many): handler: RETRY logging: LOG
INSERT (error): handler: RETRY logging: LOG
TRANSACTION (error): handler: RETRY logging: LOG
dbvrep>
dbvrep> show_conflict_handlers for default
The default handling on APPLY is set as follows:
No handler of type UPDATE (error) defined.
No handler of type UPDATE (no_data) defined.
No handler of type UPDATE (too_many) defined.
No handler of type DELETE (error) defined.
No handler of type DELETE (no_data) defined.
No handler of type DELETE (too_many) defined.
No handler of type INSERT (error) defined.
No handler of type TRANSACTION (error) defined.
 |
| Anchor | ||||
|---|---|---|---|---|
|
...