Versions Compared

Version Old Version 8 New Version 9
Changes made by

Arjen Visser

Arjen Visser

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Operations"Data" handler"Error" handler
Updatediscard | retry | overwrite | pause | abort | newer | older | sql | plsql | errordiscard | retry | overwrite | pause | abort | plsql | error
Deletediscard | retry | overwrite | pause | abort | newer | older | sql | plsql | errordiscard | retry | overwrite | pause | abort | plsql | error
Insertn/adiscard | retry | overwrite | pause | abort | plsql | error
Transactionn/adiscard | retry | overwrite | pause | abort | plsql | error

The transaction handler is used for DDL, commits etc.

The "Data" handler is used only once for a conflict – if using this handler leads to a conflict again, "Error" handler is used for the next attempt. For the next change SQL, the Data conflict will be used again. 
Additionally, logging may be specified:

...

Example setting a conflict handler on a table:

 

Section
Column
width5%

 

Column
width95
Panel
bgColorCCC
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
width5%

 

Column
width95
Panel
bgColorCCC
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