Problem

Golden Gate is a database replication technology supplied by Oracle. When installed, it adds some special tables to customer databases and adds some special columns to customer tables.

The Oracle comparison engine automatically excludes the Golden Gate columns from all database comparisons but it does not automatically exclude Golden Gate tables. It is very unlikely that you would want to include Golden Gate tables in a database comparison.

Golden Gate tables begin with the characters: DT$_

Solution

Golden Gate tables can be filtered out using a filter file with a Regex pattern to exclude tables that begin with DT$_.

Create a filter file (e.g. IgnoreRulesFile.scpf) or add a filter rule to your existing filter file if you have one:

Contents of example filter file:

{
  "filters": {
    "table": [
      "\!^DT\$_"
    ]
  }
}

Explanation of \!^DT\$_:
\! = negation
^ = start with
the \ between T and $ escapes the $ character.

Use the /ignorerules command line switch to specify the name of your filter file, e.g.

/ignorerules:IgnoreRulesFile.scpf