...
Example setting a conflict handler on a table:
| Section |
|---|
| Column |
|---|
| | Panel |
|---|
| dbvrep> SET_CONFLICT_HANDLERS FOR TABLE SCOTT.AVI_OBJECTS FOR UPDATE ON DATA TO OVERWRITE |
|
|
To show what the conflict handler has been set to:
| Section |
|---|
| Column |
|---|
| | Panel |
|---|
| dbvrep> show_conflict_handlers for table scott.avi_objects
The table called SCOTT.AVI_OBJECTS on source is handled on apply as follows:
UPDATE (error): handler: RETRY logging: LOG
UPDATE (data): handler: OVERWRITE logging: LOG
DELETE (error): handler: RETRY logging: LOG
DELETE (data): handler: RETRY logging: LOG
INSERT (error): handler: RETRY logging: LOG
TRANSACTION (error): handler: RETRY logging: LOG |
|
|
See the Command Reference or use HELP SET_CONFLICT_HANDLERS for the exact syntax.