All keywords are case-insensitive.
...
| No Format | ||
|---|---|---|
| ||
dbvrep> FILTER TABLE SCOTT.DEPT ON INSERT SET TO deptno > 50
Connecting to running apply: [Apply table removed (1 metadata record(s)). Apply table added (1 metadata record(s)).]
Filter condition on table SCOTT.DEPT set.
dbvrep>
dbvrep> FILTER SCHEMA SCOTT ON INSERT SET TO where id >20
Connecting to running apply: [Apply table removed (0 metadata record(s)). Apply table added (0 metadata record(s)).]
Filter condition on table SCOTT.BONUS set.
Connecting to running apply: [Apply table removed (0 metadata record(s)). Apply table added (0 metadata record(s)).]
Filter condition on table SCOTT.DEPT
Connecting to running apply: [Apply table removed (0 metadata record(s)). Apply table added (0 metadata record(s)).]
Filter condition on table SCOTT.EMP set.
Connecting to running apply: [Apply table removed (0 metadata record(s)). Apply table added (0 metadata record(s)).]
Filter condition on table SCOTT.SALES set.
Connecting to running apply: [Apply table removed (0 metadata record(s)). Apply table added (0 metadata record(s)).]
Filter condition on table SCOTT.SALGRADE set.
Connecting to running apply: [Apply table removed (0 metadata record(s)). Apply table added (0 metadata record(s)).]
dbvrep>
dbvrep> filter show table scott.sales
Filter conditions on table SCOTT.SALES are set as follows:
insert : deptno>50
pre-update : (no filter)
post-update: (no filter)
delete : (no filter)
dbvrep>
dbvrep> filter show schema scott
Filter conditions on schema SCOTT are set as follows:
insert : (no filter)
pre-update : (no filter)
post-update: (no filter)
delete : (no filter)
dbvrep>
|
| Anchor | ||||
|---|---|---|---|---|
|
...
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> |
...