6.99 MAPEXCLUDE

Valid For

Replicat

Description

Use the MAPEXCLUDE parameter with the MAP parameter to explicitly exclude source tables and sequences from a wildcard specification. You can use multiple MAPEXCLUDE statements for specific MAP statements.

MAPEXCLUDE is evaluated before evaluating the associated MAP parameters. Thus, the order in which they appear does not make a difference.

When using wildcards, be careful not to place them such that all objects are excluded, leaving nothing to process. For example, the following example captures nothing from cat1:

MAP cat1.schema*.tab*, TARGET schema*.tab*;
MAPEXCLUDE cat1.*.*

See also the EXCLUDEWILDCARDOBJECTSONLY parameter.

The default for resolving wildcards is WILDCARDRESOLVE DYNAMIC. Therefore, if a table that is excluded with MAPEXCLUDE is renamed to a name that satisfies a wildcard, the data will be captured. The DYNAMIC setting enables new table names that satisfy a wildcard to be resolved as soon as they are encountered and included in the Oracle GoldenGate configuration immediately. For more information, see WILDCARDRESOLVE.

Default

None

Syntax

MAPEXCLUDE [container.]owner.{table | sequence}

container.

If the source database requires three-part names, specifies the name or wildcard specification of the Oracle container that contains the object to exclude.

owner

Specifies the name or wildcard specification of the owner, such as the schema, of the object to exclude.

table | sequence

The name or wildcard specification of the source object to exclude. To specify object names and wildcards correctly, see Administering Oracle GoldenGate.

Example 1

In this example, the source tables from catalog pdb1 with schema test beginning with tab and the source table pdb2.fin.acct are excluded from the trail files:

MAPEXCLUDE pdb1.test.tab*
MAP pdb1.*.*, TARGET *.*;
MAPEXCLUDE pdb2.fin.acct
MAP pdb2.*.*, TARGET *.*;

Example 2

The following example excludes all source tables from catalog beginning with pdb, that is, it excludes all tables from pdb1, pdb2, pdb3 and so on:

MAP pdb1.*.*, TARGET *.*;
MAP pdb2.*.*, TARGET *.*;
MAPEXCLUDE pdb1.test.tab*
MAPEXCLUDE pdb*.*.*
MAPEXCLUDE pdb2.fin.acct