EXCLUDESUFFIXCHAR

Valid for

Manager

Description

Use EXCLUDESUFFIXCHAR to specify characters that are not to be used as the first character of the suffix when generating process names. This can be useful in avoiding conflicts with process naming conventions already in use.

The process name is made up of a two-character prefix, which can be set using ADD DEFINE for GGS_PREFIX (see "ADD DEFINE"), and a three character suffix. The suffix can have one or two alphanumeric characters and will end with a sequential number. The process name $GGL00, for example, uses the prefix GG. The first character of the suffix is L, indicating a Logger process, and the zeroes indicate it is the first process generated for $GGL.

Characters that are used to name Oracle GoldenGate processes are excluded by default. These include C (Coordinator), E (Extract), L (Logger), R (Replicat), and S (Server/Collector). The characters, MG, used in naming Manager processes, are also excluded by default.

Default

CELRS and MG

Syntax

EXCLUDESUFFIXCHAR characters

characters: The characters to be excluded. These should be entered as a string of characters without commas. The characters can optionally be enclosed in single or double quotation marks (e.g. "WTZ" or 'BP').

Examples

Example 1

The following examples all exclude the characters T and X from the first position of the suffix for generated process names.

EXCLUDESUFFIXCHAR TX
EXCLUDESUFFIXCHAR 'TX'
EXCLUDESUFFIXCHAR "TX"

Example 2

To reset to the defaults, enter an empty set of characters as shown below.

EXCLUDESUFFIXCHAR ""