O'Reilly logo

Instant Oracle GoldenGate by Tony Bruzzese

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Configuring advanced settings (Simple)

In this section, we'll go over some advanced settings you could apply such as filtering, mapping, and data transformation.

How to do it…

OGG, in addition to replicating, allows data filtering, mapping, extraction, and transformation. Following, you'll discover a number of other functions that OGG can perform at either the source host or target host.

  1. To capture all table changes in a schema, use the following wildcard specification:
    TABLE   SCOTT.* ;
    
  2. When you need to exclude tables from being replicated, use the tableexclude clause as follows:
    TABLEEXLCUDE SCOTT.EMP ;
    TABLE   SCOTT.* ;
    
  3. OGG allows you to filter data based on Data Manipulation Language (DML) as follows:
    
    IGNOREDELETES
    MAP SCOTT.* , TARGET SCOTT.* ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required