NAMEMATCH parameters
Valid For
GLOBALS
Description
Use the NAMEMATCH
parameters to control the behavior of fallback name mapping. Fallback name mapping is enabled by default when the source database is case-sensitive and the target database support both case-sensitive and case-insensitive object names, such as Oracle and DB2 LUW.
By default, NAMEMATCHIGNORECASE
fallback name matching works as follows: When a source table name is case-sensitive, Oracle GoldenGate applies case-sensitive wildcard mapping on the target database to find an exact match. If the target database does not contain the exact target table name, including case, fallback name mapping performs a case-insensitive target table mapping to find a name match.
Default
NAMEMATCHIGNORECASE
Syntax
NAMEMATCHIGNORECASE | NAMEMATCHNOWARNING | NAMEMATCHEXACT
-
NAMEMATCHIGNORECASE
-
Performs a case-insensitive target table mapping to find a name match when the target database does not contain the exact target table name, including case.
-
NAMEMATCHNOWARNING
-
Outputs a warning message to the report file when fallback name matching is used.
-
NAMEMATCHEXACT
-
Disables fallback name mapping. If an exact, case-sensitive match is not found, Oracle GoldenGate returns an error and abends.