3.209 WILDCARDRESOLVE

Valid For

Extract and Replicat

Description

Use the WILDCARDRESOLVE parameter to alter the rules for processing wildcarded table specifications in a TABLE, SEQUENCE, or MAP statement. WILDCARDRESOLVE must precede the associated TABLE, SEQUENCE, or MAP statements in the parameter file.

The target objects must already exist in the target database when wildcard resolution is attempted. If a target object does not exist, Replicat abends.

Default

DYNAMIC

Syntax

WILDCARDRESOLVE {DYNAMIC | IMMEDIATE}
DYNAMIC

Source objects that satisfy the wildcard definition are resolved each time the wildcard rule is satisfied. The newly resolved object is included in the Oracle GoldenGate configuration upon resolution. This is the default. This is the required setting for Teradata.

Do not use this option when SOURCEISTABLE or GENLOADFILES is specified. WILDCARDRESOLVE will always be implicitly set to IMMEDIATE for these parameters.

DYNAMIC must be used when using wildcards to replicate Oracle sequences with the SEQUENCE parameter.

To keep the default of DYNAMIC, an explicit WILDCARDRESOLVE parameter is optional, but its presence helps make it clear to someone who is reviewing the parameter file which method is being used.

IMMEDIATE

Source objects that satisfy the wildcard definition are processed at startup. This option is not supported for Teradata. This is the forced default for SOURCEISTABLE.

This option does not support the Oracle interval partitioning feature. Dynamic resolution is required so that new partitions are found by Oracle GoldenGate.

Example

The following example resolves wildcards at startup.

WILDCARDRESOLVE IMMEDIATE
TABLE hq.acct_*;