Problem

Golden Gate is a database replication technology supplied by Oracle. When installed, it adds some special tables to your database and adds some special columns to your 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$_.

Using the Command Line (CLI)

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 

Using the User Interface (UI)

Click "Edit Project..." and go to the "Ignore" tab.

Click the filter text next to "Tables"

Enter the Regex filter expression: \!^DT\$_

This means that only tables that don't begin with DT$_ will be included in your comparison.

See Using Ignore Rules for more details