MAPEXCLUDE

Valid For

Replicat

Description

Use the MAPEXCLUDE parameter with the MAP parameter to explicitly exclude source tables and sequences from a wildcard specification. MAPEXCLUDE must precede all MAP statements that contain the source objects that are being excluded. 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:

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. | catalog.]owner.{table | sequence}
container. | catalog.

If the source database requires three-part names, specifies the name or wildcard specification of the Oracle container or SQL/MX catalog 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 for Windows and UNIX.

Example

In this example, test.tab* specifies that all tables beginning with tab in schema test are to be excluded from all trail files. Table fin.acct is excluded from trail ee. Table fin.sales is excluded from trail ff.

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