Tip of the Day - Oracle & PostgreSQL (Thu, 02 Apr 2026)

Oracle Goldengate Parameter File Rules

• Parameter file resides in the <Goldengate_home_dir>/dirprm directory.

• One parameter per line.

• Use Double hypen (--) at the start of the line or after a parameter to add a comment.

• Parameters are processed in the order they appear in the file. ** Generally, Process definition (Extract / Replicat) and connection information (USERIDALIAS) listed first in the parameter file, followed by transformation/ mapping rules.

• Every Parameter has a default value.

• Every Parameter has a counter / opposite parameter.

• Validity of a parameter in parameter file exists until the counter / opposite parameter is encountered in parameter file.

• Parameter is valid for tables following that parameter. So, parameter that modify table behavior (e.g. IGNOREINSERTS, HANDLECOLLISION) must be placed before the TABLE or MAP statement that they intend to affect.

• Only the parameter TABLE, MAP, SEQUENCE, FILE, QUERY need semi-colon at the end of the line.