TABLEEXCLUDE parameter with the
SEQUENCE parameters to explicitly exclude tables and sequences from a wildcard specification. The positioning of
TABLEEXCLUDE in relation to parameters that specify files or trails determines its effect. Parameters that specify trails or files are:
RMTTRAIL. The parameter works as follows:
TABLEEXCLUDEspecification is placed before any
SEQUENCEparameters, and also before the parameters that specify trails or files, it applies globally to all trails or files, and to all
TABLEEXCLUDEspecification is placed after a parameter that specifies a trail or file, it is effective only for that trail or file and only for the
SEQUENCEparameters that are associated with it. Multiple trail or file specifications can be made in a parameter file, each followed by a set of
TABLEEXCLUDE is evaluated before evaluating the associated
SEQUENCE parameter. 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 capture. For example, the following captures nothing:
TABLE cat1.schema*.tab*; TABLEEXCLUDE cat1.*.*
The default for resolving wildcards is
WILDCARDRESOLVE DYNAMIC. Therefore, if a table that is excluded with
TABLEEXCLUDE 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.
See also the EXCLUDEWILDCARDOBJECTSONLY parameter.
If the database requires three-part names, specifies the name or wildcard specification of the Oracle container that contains the object to exclude.
Specifies the name or wildcard specification of the owner, such as the schema, of the object to exclude.
The name or wildcard specification of the object to exclude. To specify object names and wildcards correctly, see Administering Oracle GoldenGate.
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
fin.sales is excluded from trail
TABLEEXCLUDE test.tab* EXTTRAIL ./dirdat/ee TABLE pdb1.*.*; TABLEEXCLUDE pdb1.fin.acct EXTTRAIL ./dirdat/ff TABLE pdb2.*.*; TABLEEXCLUDE pdb2.fin.sales