Versions Compared

Key

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

All keywords are case-insensitive.

...

This command requires a restart of the APPLY MINE process.

Anchor
INCLUDE COLUMN
INCLUDE COLUMN
INCLUDE COLUMN

...

This command requires a restart of the APPLY MINE process.

Anchor
EXCLUDE CREATE TABLE
EXCLUDE CREATE TABLE
EXCLUDE CREATE TABLE

...

The commands add a new rule; if an existing rule of opposite meaning already exists, it is deleted instead. The matching starts with the oldest one and goes on till the newest rule added; if a reordering is needed, clear the list and start again. The SHOW option lists the existing rules using the very same syntax, so the list can be easily edited and then executed to APPLY the changes.

The This command requires a restart of the MINE process has to be restarted for this to take effect.

Anchor
INCLUDE CREATE TABLE
INCLUDE CREATE TABLE
INCLUDE CREATE TABLE

...

  1. Remove and already existing EXCLUDE CREATE TABLE rule 
  2. Add an exception to the EXCLUDE CREATE TABLE rule. For example, EXCLUDE CREATE TABLE SCOTT.TEMP%, but INCLUDE CREATE TABLE SCOTT.TEMP_REPL

The This command requires a restart of the MINE process has to be restarted for this to take effect.

Anchor
FILTER
FILTER
FILTER

...

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.

Anchor
SHOW_CONFLICT_HANDLERS
SHOW_CONFLICT_HANDLERS
SHOW_CONFLICT_HANDLERS

...