6.24 CHECKPOINTTABLE

Valid For

GLOBALS

Description

Use the CHECKPOINTTABLE parameter in a GLOBALS parameter file to specify the name of a default checkpoint table that can be used by all Replicat groups in one or more Oracle GoldenGate instances. All Replicat groups created with the ADD REPLICAT command will default to this table unless it is overridden by using the CHECKPOINTTABLE option of that command.

To create the checkpoint table, use the ADD CHECKPOINTTABLE command in GGSCI. Do not use a checkpoint table for a Replicat that is configured in integrated mode against an Oracle target database.

See Administering Oracle GoldenGate for more information about creating a checkpoint table.

Default

None

Syntax

CHECKPOINTTABLE [container.] owner.table

[container.]owner.table

The owner and name of the checkpoint table. Additionally, for an Oracle container database, specify the correct pluggable database (container).

Example

CHECKPOINTTABLE finance.ggs.chkpt